ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F26C78167A214EFBE0530100007F336B GL Balancing Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDEF379D2E0530100007F1FF2 INV Item (master) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments US Any item from item master org, including non costing enabled C6F1DC906A7E4E83E0530100007FCBE4 with cmr as ( select gsob.name ledger, haou.name operating_unit, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_bal_segment', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') balancing_segment, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acc_segment', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') account_segment, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cct_segment', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center_segment, gcc.concatenated_segments account, decode(cmr.invoice_distribution_id, null, 'INV', 'AP') transaction_source, decode(cmr.invoice_distribution_id, null,(select mtt.transaction_type_name from mtl_transaction_types mtt where cmr.transaction_type_code = to_char(mtt.transaction_type_id) ), (select crc.displayed_field from cst_reconciliation_codes crc where crc.lookup_code = cmr.transaction_type_code and crc.lookup_type in ( 'ACCRUAL WRITE-OFF ACTION','ACCRUAL TYPE') ) ) transaction_type, trunc(cmr.transaction_date) transaction_date, cmr.quantity quantity, decode(cmr.invoice_distribution_id, null, mmt.transaction_uom, pol.unit_meas_lookup_code) uom, cmr.amount accounted_amount, cmr.entered_amount entered_amount, cmr.currency_code entered_currency, pov.vendor_name vendor, apia.invoice_num invoice_number, aida.invoice_line_number invoice_line, nvl(poh.clm_document_number,poh.segment1) po_number, por.release_num po_release, nvl(POL.line_num_display, to_char(POL.line_num)) po_line, poll.shipment_num po_shipment, pod.distribution_num po_distribution, cmr.po_distribution_id po_distribution_id, ( select rsh.receipt_num from rcv_shipment_headers rsh, rcv_transactions rt where rsh.shipment_header_id = rt.shipment_header_id and rt.transaction_id = mmt.rcv_transaction_id and mmt.source_code = 'RCV' and rownum=1 ) receipt_number, cmr.inventory_transaction_id inventory_transaction_id, nvl2(cmr.inventory_item_id, (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id = cmr.inventory_item_id and msiv.organization_id = nvl(mp.organization_id,msiv.organization_id) and rownum <2 ), null) item, nvl2(cmr.inventory_item_id, (select msiv.description from mtl_system_items_vl msiv where msiv.inventory_item_id = cmr.inventory_item_id and msiv.organization_id = nvl(mp.organization_id,msiv.organization_id) and rownum <2 ), null) item_description, nvl2(cmr.inventory_item_id, (select xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) from mtl_system_items_vl msiv where msiv.inventory_item_id = cmr.inventory_item_id and msiv.organization_id = nvl(mp.organization_id,msiv.organization_id) and rownum <2 ), null) user_item_type, mp.organization_code inventory_organization from cst_misc_reconciliation cmr, ap_invoices_all apia, ap_invoice_distributions_all aida, po_vendors pov, mtl_parameters mp, gl_code_combinations_kfv gcc, po_distributions_all pod, po_line_locations_all poll, po_releases_all por, po_lines_all pol, po_headers_all poh, mtl_material_transactions mmt, cst_accrual_accounts caa, hr_all_organization_units haou, hr_organization_information hoi, gl_sets_of_books gsob where cmr.invoice_distribution_id = aida.invoice_distribution_id(+) and aida.invoice_id = apia.invoice_id(+) and cmr.vendor_id = pov.vendor_id(+) and cmr.inventory_organization_id = mp.organization_id(+) and cmr.accrual_account_id = gcc.code_combination_id and cmr.accrual_account_id = caa.accrual_account_id and caa.operating_unit_id = cmr.operating_unit_id and pod.po_distribution_id(+) = cmr.po_distribution_id and cmr.inventory_transaction_id = mmt.transaction_id (+) and poll.line_location_id(+) = pod.line_location_id and pod.po_release_id = por.po_release_id(+) and pol.po_line_id(+) = pod.po_line_id and poh.po_header_id(+) = pod.po_header_id and cmr.operating_unit_id = haou.organization_id and hoi.organization_id = haou.organization_id and hoi.org_information_context = 'Operating Unit Information' and gsob.set_of_books_id = to_number(hoi.org_information3) ) -- -- Main Query Starts Here select cmr.*, case when cmr.transaction_source = 'AP' then 'AP: ' || cmr.invoice_number else case when cmr.po_number is not null then 'PO: ' || cmr.po_number else case when cmr.receipt_number is not null then 'RCV: ' || cmr.receipt_number else 'INV: ' || cmr.inventory_transaction_id end end end transaction_ref, decode( :p_sort_by , 'ITEM', item, 'AMOUNT', decode(sign(cmr.accounted_amount),-1, chr(0) || translate( to_char(abs(cmr.accounted_amount), '000000000999.999'), '0123456789', '9876543210'), to_char(cmr.accounted_amount, '000000000999.999' ) ), 'DATE', to_char(cmr.transaction_date, 'yyyymmddhh24miss') ) sort_key from cmr where 1=1 order by sort_key Y AR CST تقرير تسوية الاستحقاقات المتنوعة Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: D CST Wareneingang - sonstige Rückstellung abstimmen Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: E CST Otra Conciliación de Acumulaciones Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: F CST Etat de rapprochement des provisions diverses Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: I CST Rapporto Quadratura accantonamenti vari Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: JA CST その他経過勘定調整レポート Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: KO CST 기타 미지급 대사 보고서 Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: PTB CST Relatório de Diversos de Reconciliação da Provisão Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: RU CST Отчет о выверке прочих начислений Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: S CST Diverse periodiseringar - avstämningsrapport Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: TR CST Muhtelif Tahakkuka Dayalı Mutabakat Raporu Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: US CST Miscellaneous Accrual Reconciliation Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: ZHS CST 杂项应计调节报表 Imported from Concurrent Program Application: Bills of Material Source: Miscellaneous Accrual Reconciliation Report Short Name: CSTACRMI DB package: Enginatics R12 only 1=1 :p_sort_by 1 10 1=1 cmr.operating_unit = :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 cmr.balancing_segment >= :p_bal_segment_from LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value AR مقطع الترصيد من D Von Buchungskreis F Segment d'équilibrage Du I Segmento quadratura - Da US Balancing Segment From ZHS 平衡段自 3 30 1=1 cmr.balancing_segment <= :p_bal_segment_to LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value :$flex$.balancing_segment_from AR مقطع الترصيد إلى D Bis Buchungskreis F Segment d'équilibrage à I Segmento quadratura - A US Balancing Segment To ZHS 平衡段至 4 40 1=1 cmr.account = :p_accrual_account LOV custom Y select gcck.concatenated_segments value, null description from hr_operating_units hou, cst_accrual_accounts cac, gl_code_combinations_kfv gcck where cac.operating_unit_id = hou.organization_id and gcck.code_combination_id = cac.accrual_account_id and xxen_util.contains(:$flex$.Operating_Unit,hou.name) = 'Y' order by gcck.concatenated_segments F Compte de régularisation US Accrual Account 5 50 1=1 cmr.transaction_date >= :p_from_date Date AR أيام فترة التقادم D Fälligkeitsperiode in Tagen F Date du I Periodo scadenziario (giorni) US Date From ZHS 以天数为单位的帐龄分期 6 60 1=1 cmr.transaction_date < :p_to_date + 1 Date :$flex$.date_from F Date à US Date To 7 70 1=1 cmr.accounted_amount >= :p_from_amount Number AR الحد الأدنى للرصيد المستحق D Ausstehender Mindestsaldo F Montant minimum I Saldo minimo in sospeso US Minimum Amount ZHS 最小未付余额 8 80 1=1 cmr.accounted_amount <= :p_to_amount Number :$flex$.minimum_amount AR الحد الأقصى للرصيد المستحق D Ausstehender Höchstsaldo F Montant maximal I Saldo massimo in sospeso US Maximum Amount ZHS 最大未付余额 9 90 1=1 cmr.item >= :p_from_item LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments AR الصنف من D Von Artikel F Article de I Articolo - Da US Item From ZHS 物料自 10 100 1=1 cmr.item <= :p_to_item LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by msiv.concatenated_segments :$flex$.item_from AR الصنف إلى D Bis Artikel F Objet à I Articolo - A US Item To ZHS 物料至 11 110 1=1 cmr.invoice_number = :p_invoice_num LOV custom Y select ai.invoice_num value, aps.vendor_name||' ('||ai.invoice_date||')' description from ap_invoices ai, ap_suppliers aps where ai.vendor_id=aps.vendor_id(+) and ai.invoice_id in (select aid.invoice_id from ap_invoice_distributions aid, cst_misc_reconciliation cmr, hr_operating_units hou where aid.invoice_distribution_id = cmr.invoice_distribution_id and cmr.operating_unit_id = hou.organization_id and xxen_util.contains(:$flex$.operating_unit,hou.name)='Y' ) order by ai.creation_date desc F Numéro de facture US Invoice Number 12 120 1=1 cmr.invoice_line = :p_invoice_line Number F Ligne de facturation US Invoice Line 13 130 1=1 cmr.po_number = :p_po_num LOV custom Y Y select ph.segment1 value, xxen_util.meaning(ph.type_lookup_code,'PO TYPE',201)||nvl2(aps.vendor_name,': '||aps.vendor_name,null) description from po_headers_all ph, ap_suppliers aps where ph.vendor_id=aps.vendor_id(+) and ph.po_header_id in (select pd.po_header_id from po_distributions pd, cst_misc_reconciliation cmr, hr_operating_units hou where pd.po_distribution_id = cmr.po_distribution_id and cmr.operating_unit_id = hou.organization_id and xxen_util.contains(:$flex$.operating_unit,hou.name)='Y' ) order by ph.creation_date desc F Numéro de PO US PO Number 14 140 1=1 cmr.po_release = :p_release_num LOV custom Y select pr.release_num value, ph.segment1 || ': ' || pr.release_num || ' ' || trunc(pr.release_date) description from po_releases pr, po_headers ph, hr_operating_units hou where pr.po_header_id = ph.po_header_id and ph.org_id = hou.organization_id and ph.segment1 = :$flex$.po_number and xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y' and exists (select null from po_line_locations pll, po_distributions pd, cst_misc_reconciliation cmr where pll.po_release_id = pr.po_release_id and pll.line_location_id = pd.line_location_id and pd.po_distribution_id = cmr.po_distribution_id ) order by pr.release_num desc F Communiqué de presse US PO Release 15 150 1=1 cmr.po_line = :p_po_line_num Number F Ligne PO US PO Line 16 160 1=1 cmr.po_shipment = :p_po_shipment_num Number F Expédition par PO US PO Shipment 17 170 1=1 cmr.transaction_type = :p_trx_type LOV custom Y select value, null description from (select distinct mtt.transaction_type_name value from mtl_transaction_types mtt where exists (select null from cst_misc_reconciliation cmr where cmr.transaction_type_code = to_char(mtt.transaction_type_id) ) union select crc.displayed_field value from cst_reconciliation_codes crc where crc.lookup_type in ( 'ACCRUAL WRITE-OFF ACTION','ACCRUAL TYPE') and exists (select null from cst_misc_reconciliation cmr where cmr.transaction_type_code = crc.lookup_code ) ) order by value F Type de transaction US Transaction Type 18 180 1=1 cmr.inventory_transaction_id = :p_inv_trx_id Number F ID de la transaction d'inventaire US Inventory Transaction Id 19 190 :p_sort_by LOV Oracle CST_SRS_CSTACRMI_SORT Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='SRS ACCRUAL ORDER BY' and lookup_code in ('ITEM','DATE','AMOUNT') and language=userenv('LANG') order by lookup_code DATE Y AR فرز بواسطة D Sortieren nach F Trier par I Ordina per US Sort By ZHS 排序依据 :$flex$.Operating_Unit Operating Unit Accrual Account :$flex$.balancing_segment_from Balancing Segment From Balancing Segment To :$flex$.date_from Date From Y Date To :$flex$.item_from Item From Item To :$flex$.minimum_amount Minimum Amount Maximum Amount :$flex$.operating_unit Operating Unit Balancing Segment From :$flex$.operating_unit Operating Unit Balancing Segment To :$flex$.operating_unit Operating Unit Invoice Number :$flex$.operating_unit Operating Unit PO Number :$flex$.operating_unit Operating Unit PO Release :$flex$.po_number PO Number PO Release Pivot - Total Accounted Amount by Account, Transaction Type, Vendor, Transaction SYSADMIN 6 ACCOUNT 12 ACCOUNTED_AMOUNT 4 ACCOUNT_SEGMENT 3 BALANCING_SEGMENT 5 COST_CENTER_SEGMENT 13 ENTERED_AMOUNT 14 ENTERED_CURRENCY 27 INVENTORY_ORGANIZATION 25 INVENTORY_TRANSACTION_ID 17 INVOICE_LINE 16 INVOICE_NUMBER 26 ITEM 1 LEDGER 2 OPERATING_UNIT 22 PO_DISTRIBUTION 23 PO_DISTRIBUTION_ID 20 PO_LINE 18 PO_NUMBER 19 PO_RELEASE 21 PO_SHIPMENT 10 QUANTITY 24 RECEIPT_NUMBER 9 TRANSACTION_DATE 28 TRANSACTION_REF 7 TRANSACTION_SOURCE 8 TRANSACTION_TYPE 11 UOM 15 VENDOR ACCOUNT ROW 1 ACCOUNTED_AMOUNT VALUE 1 SUM ACCOUNT_SEGMENT FILTER 4 BALANCING_SEGMENT FILTER 3 COST_CENTER_SEGMENT FILTER 5 ITEM FILTER 6 LEDGER FILTER 1 OPERATING_UNIT FILTER 2 TRANSACTION_REF ROW 4 TRANSACTION_TYPE ROW 2 VENDOR ROW 3 S Site Pivot - Total Accounted Amount by Account, Transaction Type, Vendor, Transaction