ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 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 C6E710EC20CBF806E0530100007FFB45 with capr 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, crc.displayed_field transaction_type, decode(capr.invoice_distribution_id, NULL, decode(capr.write_off_id, NULL, 'PO', 'WO'), 'AP') transaction_source, trunc(capr.transaction_date) transaction_date, 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, nvl(poll.price_override,pol.unit_price) unit_price, pod.quantity_ordered, pod.quantity_cancelled, pod.quantity_delivered, pod.quantity_billed, (select papf.full_name from per_all_people_f papf where poh.agent_id=papf.person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) buyer, (select papf.full_name from per_all_people_f papf where pod.deliver_to_person_id=papf.person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) deliver_to_person, nvl(poh.clm_document_number,poh.segment1) || nvl2(por.release_num,' (' || por.release_num || ')','') po_num_rel_ref, nvl(poh.clm_document_number,poh.segment1) || nvl2(por.release_num,' (' || por.release_num || ')','') || ' - ' || nvl(pol.line_num_display, to_char(pol.line_num)) || '/' || poll.shipment_num || '/' || pod.distribution_num po_num_rel_line_ship_dist_ref, rsh.receipt_num receipt_number, crs.po_balance po_balance, crs.ap_balance ap_balance, crs.write_off_balance wo_balance, (nvl(crs.po_balance,0) + nvl(crs.ap_balance,0) + nvl(crs.write_off_balance,0)) total_balance, gsob.currency_code currency, capr.quantity transaction_quantity, decode(capr.write_off_id, NULL, pol.unit_meas_lookup_code, NULL ) uom, capr.amount accounted_amount, capr.entered_amount entered_amount, capr.currency_code entered_currency, trunc(sysdate - decode(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS'), 1, nvl(crs.last_receipt_date,crs.last_invoice_dist_date), greatest(nvl(crs.last_receipt_date,crs.last_invoice_dist_date), nvl(crs.last_invoice_dist_date, crs.last_receipt_date)) ) ) age_in_days, nvl2(crs.inventory_item_id, (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id = crs.inventory_item_id and msiv.organization_id = nvl(capr.inventory_organization_id,msiv.organization_id) and rownum <2 ), null) item, nvl2(crs.inventory_item_id, (select msiv.description from mtl_system_items_vl msiv where msiv.inventory_item_id = crs.inventory_item_id and msiv.organization_id = nvl(capr.inventory_organization_id,msiv.organization_id) and rownum <2 ), null) item_description, nvl2(crs.inventory_item_id, (select xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) from mtl_system_items_vl msiv where msiv.inventory_item_id = crs.inventory_item_id and msiv.organization_id = nvl(capr.inventory_organization_id,msiv.organization_id) and rownum <2 ), null) user_item_type, decode(capr.inventory_organization_id, NULL, NULL, mp.organization_code) inventory_organization, pdt.displayed_field destination, crs.po_distribution_id po_distribution_id, capr.write_off_id write_off_id, -- nvl(:p_aging_days,0) aging_days, decode(nvl(:p_aging_days,0), 0, 0, floor( ( sysdate - decode(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS'), 1, nvl(crs.last_receipt_date,crs.last_invoice_dist_date), greatest(nvl(crs.last_receipt_date,crs.last_invoice_dist_date), nvl(crs.last_invoice_dist_date, crs.last_receipt_date)) )) / decode(nvl(:p_aging_days,0),0,1,:p_aging_days))*nvl(:p_aging_days,0)) aging_period_days_from, decode(nvl(:p_aging_days,0), 0, 0, ceil(( sysdate - decode(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS'), 1, nvl(crs.last_receipt_date,crs.last_invoice_dist_date), greatest(nvl(crs.last_receipt_date,crs.last_invoice_dist_date), nvl(crs.last_invoice_dist_date, crs.last_receipt_date)) ) ) / decode(nvl(:p_aging_days,0),0,1,:p_aging_days))*nvl(:p_aging_days,0)-1) aging_period_days_to from cst_reconciliation_codes crc, cst_ap_po_reconciliation capr, ap_invoices_all apia, ap_invoice_distributions_all aida, mtl_parameters mp, rcv_transactions rct, rcv_shipment_headers rsh, cst_reconciliation_summary crs, po_distributions_all pod, po_line_locations_all poll, po_releases_all por, po_lines_all pol, po_headers_all poh, po_vendors pov, po_destination_types_all_v pdt, gl_code_combinations_kfv gcc, cst_accrual_accounts caa, hr_all_organization_units haou, hr_organization_information hoi, gl_sets_of_books gsob where crc.lookup_code = to_char(capr.transaction_type_code) and crc.lookup_type in ( 'RCV TRANSACTION TYPE', 'ACCRUAL WRITE-OFF ACTION','ACCRUAL TYPE') and aida.invoice_distribution_id(+) = capr.invoice_distribution_id and apia.invoice_id(+) = aida.invoice_id and mp.organization_id(+) = capr.inventory_organization_id and rct.transaction_id(+) = capr.rcv_transaction_id and rsh.shipment_header_id(+) = rct.shipment_header_id and capr.po_distribution_id = crs.po_distribution_id and crs.accrual_account_id = capr.accrual_account_id and pod.po_distribution_id = crs.po_distribution_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 pdt.lookup_code(+) = crs.destination_type_code and pov.vendor_id(+) = crs.vendor_id and crs.accrual_account_id = gcc.code_combination_id and crs.accrual_account_id = caa.accrual_account_id and caa.operating_unit_id = crs.operating_unit_id and capr.operating_unit_id = crs.operating_unit_id and crs.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 distinct capr.ledger, capr.operating_unit, capr.balancing_segment, capr.account_segment, capr.cost_center_segment, capr.account, capr.vendor, capr.po_number, capr.po_release, capr.po_line, capr.po_shipment, capr.po_distribution, capr.po_distribution_id, capr.unit_price, capr.quantity_ordered, capr.quantity_cancelled, capr.quantity_delivered, capr.quantity_billed, capr.buyer, capr.deliver_to_person, capr.po_balance, capr.ap_balance, capr.wo_balance, capr.total_balance, capr.age_in_days, capr.destination, capr.item, capr.item_description, capr.user_item_type, -- null transaction_source, null transaction_type, to_date(null) transaction_date, to_number(null) transaction_quantity, null uom, to_number(null) accounted_amount, to_number(null) entered_amount, null entered_currency, null invoice_number, to_number(null) invoice_line, null receipt_number, null inventory_organization, to_number(null) write_off_id, 'Balance' record_type, capr.po_num_rel_ref, capr.po_num_rel_line_ship_dist_ref, capr.aging_period_days_from, capr.aging_period_days_to, case nvl(:p_aging_days,0) when 0 then 'All Aging Period Days' else to_char(capr.aging_period_days_from,'999990') || ' - ' || to_char(capr.aging_period_days_to) || ' Days' end aging_period_days, decode(:p_sort_by, 'ITEM' , capr.item, 'AGE IN DAYS', decode(sign(capr.age_in_days),-1, chr(0) || translate( to_char(abs(capr.age_in_days), '000000000999.999'), '0123456789', '9876543210'), to_char(capr.age_in_days , '000000000999.999' ) ), 'VENDOR', vendor, 'TOTAL BALANCE', decode(sign(capr.total_balance),-1, chr(0) || translate( to_char(abs(capr.total_balance), '000000000999.999'), '0123456789', '9876543210'),to_char(capr.total_balance, '000000000999.999' ) ), 'PO NUMBER', capr.po_number ) sort_key from capr where 1=1 union all select capr.ledger, capr.operating_unit, capr.balancing_segment, capr.account_segment, capr.cost_center_segment, capr.account, capr.vendor, capr.po_number, capr.po_release, capr.po_line, capr.po_shipment, capr.po_distribution, capr.po_distribution_id, capr.unit_price, capr.quantity_ordered, capr.quantity_cancelled, capr.quantity_delivered, capr.quantity_billed, capr.buyer, capr.deliver_to_person, to_number(null) po_balance, to_number(null) ap_balance, to_number(null) wo_balance, to_number(null) total_balance, capr.age_in_days, capr.destination, capr.item, capr.item_description, capr.user_item_type, -- capr.transaction_source, capr.transaction_type, capr.transaction_date, capr.transaction_quantity, capr.uom, capr.accounted_amount, capr.entered_amount, capr.entered_currency, capr.invoice_number, capr.invoice_line, capr.receipt_number, capr.inventory_organization, capr.write_off_id, 'Transaction' record_type, capr.po_num_rel_ref, capr.po_num_rel_line_ship_dist_ref, capr.aging_period_days_from, capr.aging_period_days_to, case nvl(:p_aging_days,0) when 0 then 'All Aging Period Days' else to_char(capr.aging_period_days_from,'999990') || ' - ' || to_char(capr.aging_period_days_to) || ' Days' end aging_period_days, decode(:p_sort_by, 'ITEM' , capr.item, 'AGE IN DAYS', decode(sign(capr.age_in_days),-1, chr(0) || translate( to_char(abs(capr.age_in_days), '000000000999.999'), '0123456789', '9876543210'), to_char(capr.age_in_days , '000000000999.999' ) ), 'VENDOR', vendor, 'TOTAL BALANCE', decode(sign(capr.total_balance),-1, chr(0) || translate( to_char(abs(capr.total_balance), '000000000999.999'), '0123456789', '9876543210'),to_char(capr.total_balance, '000000000999.999' ) ), 'PO NUMBER', capr.po_number ) sort_key from capr where 1=1 and :p_show_transactions = 'Y' order by sort_key, po_number, po_release, po_line, po_shipment, po_distribution, record_type Y AR CST تقرير تسوية الاستحقاقات لكل من حساب المدفوعات وأمر الشراء Imported from Concurrent Program Application: شجرة المنتجات Source: تقرير تسوية الاستحقاقات لكل من حساب المدفوعات وأمر الشراء Short Name: CSTACRAP DB package: D CST KR und EK: Wareneingang - Rückstellung abstimmen Imported from Concurrent Program Application: Produktionsdaten Source: KR und EK: Wareneingang - Rückstellung abstimmen Short Name: CSTACRAP DB package: F CST Etat de rapprochement des provisions AP et PO Imported from Concurrent Program Application: Bills of Material Source: Etat de rapprochement des provisions AP et PO Short Name: CSTACRAP DB package: I CST Rapporto Quadratura accantonamento AP e PO Imported from Concurrent Program Application: Bills of Material Source: Rapporto Quadratura accantonamento AP e PO Short Name: CSTACRAP DB package: US CST AP and PO Accrual Reconciliation Imported from Concurrent Program Application: Bills of Material Source: AP and PO Accrual Reconciliation Report Short Name: CSTACRAP ZHS CST AP 和 PO 应计调节报表 Imported from Concurrent Program Application: 物料清单管理系统 Source: AP 和 PO 应计调节报表 Short Name: CSTACRAP DB package: Enginatics R12 only 1=1 :p_aging_days :p_show_transactions :p_sort_by 1 10 1=1 capr.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 :p_show_transactions LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y F Afficher les détails de la transaction US Show Transaction Details 3 30 1=1 capr.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 平衡段自 4 40 1=1 capr.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 平衡段至 5 50 1=1 capr.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 6 60 :p_aging_days Number 0 Y AR أيام فترة التقادم D Fälligkeitsperiode in Tagen F Période de vieillissement Jours I Periodo scadenziario (giorni) US Aging Period Days ZHS 以天数为单位的帐龄分期 7 70 1=1 capr.age_in_days >= :p_from_age_days Number F Âge minimum en jours US Minimum Age in Days 8 80 1=1 capr.age_in_days <= :p_to_age_days Number :$flex$.minimum_age_in_days F Âge maximal en jours US Maximum Age in Days 9 90 1=1 capr.total_balance >= :p_from_amount Number AR الحد الأدنى للرصيد المستحق D Ausstehender Mindestsaldo F Solde minimum impayé I Saldo minimo in sospeso US Minimum Outstanding Balance ZHS 最小未付余额 10 100 1=1 capr.total_balance <= :p_to_amount Number :$flex$.minimum_outstanding_balance AR الحد الأقصى للرصيد المستحق D Ausstehender Höchstsaldo F Solde impayé maximal I Saldo massimo in sospeso US Maximum Outstanding Balance ZHS 最大未付余额 11 110 1=1 capr.item=: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 I Articolo - Da US Item ZHS 物料自 12 120 1=1 capr.vendor=:vendor LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id AR المورد من D Von Lieferant F Vendeur I Fornitore - Da US Vendor ZHS 供应商自 13 130 1=1 capr.po_number = :po_number 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_reconciliation_summary crs, hr_operating_units hou where pd.po_distribution_id = crs.po_distribution_id and crs.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 capr.po_release = :po_release 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_reconciliation_summary crs where pll.po_release_id = pr.po_release_id and pll.line_location_id = pd.line_location_id and pd.po_distribution_id = crs.po_distribution_id ) order by pr.release_num desc F Communiqué de presse US PO Release 15 150 1=1 capr.po_line = :po_line Number F Ligne PO US PO Line 16 160 1=1 capr.po_shipment = :po_shipment Number F Expédition par PO US PO Shipment 17 170 1=1 capr.destination = :p_detination_type LOV custom Y select pdtav.displayed_field value, null description from po_destination_types_all_v pdtav order by pdtav.displayed_field F Type de destination US Destination Type 18 180 :p_sort_by LOV Oracle CST_SRS_CSTACRAP_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','VENDOR','PO NUMBER', 'AGE IN DAYS','TOTAL BALANCE') and language=userenv('LANG') order by lookup_code PO NUMBER 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$.minimum_age_in_days Minimum Age in Days Maximum Age in Days :$flex$.minimum_outstanding_balance Minimum Outstanding Balance Maximum Outstanding Balance :$flex$.operating_unit Operating Unit Balancing Segment From :$flex$.operating_unit Operating Unit Balancing Segment To :$flex$.operating_unit Operating Unit PO Number :$flex$.operating_unit Operating Unit PO Release :$flex$.operating_unit Operating Unit Vendor :$flex$.po_number PO Number PO Release FC2BFB697180F17F978D4D82DA1081A9 Pivot - Totals by Account, Aging Bucket, Vendor, Transaction SYSADMIN 6 ACCOUNT 35 ACCOUNTED_AMOUNT 4 ACCOUNT_SEGMENT 25 AGE_IN_DAYS 48 AGING_PERIOD_DAYS 46 AGING_PERIOD_DAYS_FROM 47 AGING_PERIOD_DAYS_TO 22 AP_BALANCE 3 BALANCING_SEGMENT 19 BUYER 5 COST_CENTER_SEGMENT 20 DELIVER_TO_PERSON 29 DESTINATION 36 ENTERED_AMOUNT 37 ENTERED_CURRENCY 41 INVENTORY_ORGANIZATION 39 INVOICE_LINE 38 INVOICE_NUMBER 26 ITEM 27 ITEM_DESCRIPTION 1 LEDGER 1 2 OPERATING_UNIT 21 PO_BALANCE 12 PO_DISTRIBUTION 8 13 PO_DISTRIBUTION_ID 10 PO_LINE 6 8 PO_NUMBER 4 45 PO_NUM_REL_LINE_SHIP_DIST_REF 44 PO_NUM_REL_REF 9 PO_RELEASE 5 11 PO_SHIPMENT 7 18 QUANTITY_BILLED 16 QUANTITY_CANCELLED 17 QUANTITY_DELIVERED 15 QUANTITY_ORDERED 40 RECEIPT_NUMBER 43 RECORD_TYPE 9 49 SORT_KEY 3 24 TOTAL_BALANCE 32 TRANSACTION_DATE 33 TRANSACTION_QUANTITY 30 TRANSACTION_SOURCE 31 TRANSACTION_TYPE 14 UNIT_PRICE 34 UOM 28 USER_ITEM_TYPE 7 VENDOR 23 WO_BALANCE 42 WRITE_OFF_ID ACCOUNT ROW 1 ACCOUNT_SEGMENT FILTER 4 AGE_IN_DAYS VALUE 5 AVG AGING_PERIOD_DAYS ROW 2 AP_BALANCE VALUE 2 SUM BALANCING_SEGMENT FILTER 3 COST_CENTER_SEGMENT FILTER 5 ITEM FILTER 7 LEDGER FILTER 1 OPERATING_UNIT FILTER 2 PO_BALANCE VALUE 1 SUM PO_NUM_REL_REF ROW 4 TOTAL_BALANCE VALUE 4 SUM USER_ITEM_TYPE FILTER 6 VENDOR ROW 3 WO_BALANCE VALUE 3 SUM S Site FC2BFB697180F17F978D4D82DA1081A9