ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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）限制的操作单元。 31BBF4BFDA1E0AD9E06362FB090507AEY SELECT 1 C_dummy_break, rdv.po_number po_number, rdv.code_combination_id ccid, null C_FLEX_ITEM, null C_FLEX_ACC, null C_FLEX_CAT, rdv.item_id item_id, rdv.transaction_id trx_id, rdv.accounting_date acct_date, round((decode(rdv.event_type_id, 15, DECODE(accounting_line_type, 'Receiving Inspection', 1, -1), 16, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), 17, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), Decode(rdv.accounting_line_type, 'Landed Cost Absorption', Sign(po_unit_price - unit_landed_cost), 1) * decode(rdv.entered_dr,NULL, -1, 1)) * rdv.primary_quantity) * rdv.source_doc_quantity / rdv.total_source_doc_quantity, :P_qty_precision) qty, decode(rdv.event_type_id, 15, DECODE(accounting_line_type, 'Receiving Inspection', 1, -1), 16, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), 17, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), Decode(rdv.accounting_line_type, 'Landed Cost Absorption', Sign(po_unit_price - unit_landed_cost), 1) * decode(rdv.entered_dr,NULL, -1, 1)) * rdv.primary_quantity * rdv.source_doc_quantity / rdv.total_source_doc_quantity primary_qty, decode(rdv.event_type_id, 15, DECODE(accounting_line_type, 'Receiving Inspection', 1, -1), 16, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), 17, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), Decode(rdv.accounting_line_type, 'Landed Cost Absorption', Sign(po_unit_price - unit_landed_cost), 1) * decode(rdv.entered_dr,NULL, -1, 1)) * rdv.primary_quantity raw_qty, rdv.primary_uom uom, round(rdv.po_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8) primary_unit_price, round(rdv.prior_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8) prior_unit_price, round(rdv.unit_landed_cost * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8) primary_landed_cost, rdv.line_number line_num, rdv.destination_type dest_type, rdv.deliver_to_location deliver_to_location, rdv.currency_code currency_code, NVL(rdv.currency_conversion_rate ,1) curr_conv_rate, (rdv.total_source_doc_quantity/rdv.primary_quantity) po_to_pr_uom_rate, rdv.receipt_number receipt_num, rdv.item_revision rev, rdv.category_id cat, rdv.item_description item_des, NVL(raet.description, rdv.transaction_type) transaction_type, rdv.organization_id organization_id1, rdv.packing_slip packing_slip, round(rdv.source_doc_quantity, :P_qty_precision) source_doc_quantity, rdv.entered_dr entered_dr, rdv.primary_quantity primary_quantity, pov.vendor_name vendor_name, pov.segment1 vendor_number, decode(:P_sort_id,1,rdv.primary_uom) c_uom, decode(:P_sort_id,1,rdv.item_revision) c_rev, decode(:P_sort_id,1,rdv.item_description ) c_des, decode(:P_sort_id,1,msv.concatenated_segments, 2,pov.vendor_name, 3,rdv.receipt_number,1) C_break_column, mp.organization_code to_org, gsob.chart_of_accounts_id coa_id, gsob.currency_code func_currency_code, rdv.accounting_event_id acc_event_id, rdv.event_type_id event_type_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ACC_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_FLEX_ACC_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price1formula(rdv.accounting_event_id, rdv.transaction_id, round ( rdv.po_unit_price * ( rdv.total_source_doc_quantity / rdv.primary_quantity ) , 8 ), ( rdv.total_source_doc_quantity / rdv.primary_quantity )) C_PRIMARY_UNIT_PRICE1, PO_POXRRVDR_XMLP_PKG.c_sort_main_dispformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_sort_main_disp, PO_POXRRVDR_XMLP_PKG.c_cat_dispformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')) C_cat_disp, PO_POXRRVDR_XMLP_PKG.c_vendorformula(pov.vendor_name) C_vendor, PO_POXRRVDR_XMLP_PKG.c_vendor_numberformula(pov.segment1) C_vendor_number, PO_POXRRVDR_XMLP_PKG.display_column(rdv.deliver_to_location,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_item_loc_disp, PO_POXRRVDR_XMLP_PKG.price(rdv.entered_dr,round(rdv.po_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8)) C_primary_unit_price, PO_POXRRVDR_XMLP_PKG.calc_trx_value(rdv.currency_code, :C_PRECISION, rdv.event_type_id, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price1formula(rdv.accounting_event_id, rdv.transaction_id, round ( rdv.po_unit_price * ( rdv.total_source_doc_quantity / rdv.primary_quantity ) , 8 ), ( rdv.total_source_doc_quantity / rdv.primary_quantity )), decode(rdv.event_type_id, 15, DECODE(accounting_line_type, 'Receiving Inspection', 1, -1), 16, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), 17, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), decode(rdv.entered_dr,NULL, -1, 1)) * rdv.primary_quantity * rdv.source_doc_quantity / rdv.total_source_doc_quantity, NVL(rdv.currency_conversion_rate ,1) , round(rdv.prior_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8), round(rdv.unit_landed_cost, 8), rdv.accounting_line_type) C_TRX_VALUE, PO_POXRRVDR_XMLP_PKG.c_quantityformula(rdv.event_type_id,round((decode(rdv.event_type_id, 15, DECODE(accounting_line_type, 'Receiving Inspection', 1, -1), 16, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), 17, DECODE(accounting_line_type, 'Receiving Inspection', -1, 1), Decode(rdv.accounting_line_type, 'Landed Cost Absorption', Sign(po_unit_price - unit_landed_cost), 1) * decode(rdv.entered_dr,NULL, -1, 1)) * rdv.primary_quantity) * rdv.source_doc_quantity / rdv.total_source_doc_quantity, :P_qty_precision)) C_QUANTITY, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price2formula(rdv.event_type_id, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price1formula(rdv.accounting_event_id, rdv.transaction_id, round ( rdv.po_unit_price * ( rdv.total_source_doc_quantity / rdv.primary_quantity ) , 8 ), ( rdv.total_source_doc_quantity / rdv.primary_quantity )), round(rdv.unit_landed_cost , 8), round(rdv.prior_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8), rdv.accounting_line_type, NVL(rdv.currency_conversion_rate ,1)) C_PRIMARY_UNIT_PRICE2, rdv.accounting_line_type FROM mtl_system_items_kfv msv , rcv_receiving_acct_distr_v rdv , mtl_item_categories mic , mtl_system_items msi , gl_code_combinations gcc , mtl_categories mca , po_vendors pov , mtl_parameters mp , gl_sets_of_books gsob , rcv_accounting_event_types raet WHERE msi.inventory_item_id = rdv.item_id AND rdv.actual_flag = 'A' AND msi.organization_id = :organization_id AND rdv.item_id is not null AND mic.organization_id = :organization_id AND mic.inventory_item_id = rdv.item_id AND mic.category_set_id = nvl(:P_cat_set_id,mic.category_set_id) AND mic.category_id = mca.category_id AND msv.inventory_item_id = rdv.item_id AND nvl(msv.organization_id,:organization_id) = :organization_id AND gcc.code_combination_id = rdv.code_combination_id AND &P_WHERE_CAT AND &P_WHERE_ITEM AND &P_WHERE_ACC AND &P_WHERE_ACCOUNTING_DATE_FROM AND &P_WHERE_ACCOUNTING_DATE_TO AND &P_where_trx_date_from AND &P_Where_trx_date_to AND pov.vendor_id = rdv.vendor_id AND rdv.organization_id = nvl(:P_org_id,rdv.organization_id) AND rdv.organization_id = mp.organization_id AND &P_WHERE_VENDOR AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND rdv.set_of_books_id = gsob.set_of_books_id AND rdv.event_type_id = raet.event_type_id (+) UNION ALL SELECT 1 C_dummy_break, rdv.po_number po_number, rdv.code_combination_id ccid, NULL C_FLEX_ITEM, null C_FLEX_ACC, null C_FLEX_CAT, rdv.item_id item_id, rdv.transaction_id trx_id, rdv.accounting_date acct_date, round(decode(rdv.entered_dr,NULL,rdv.primary_quantity* -1,rdv.primary_quantity) * rdv.source_doc_quantity / rdv.total_source_doc_quantity,:P_qty_precision) qty, decode(rdv.entered_dr,NULL,rdv.primary_quantity* -1,rdv.primary_quantity) * rdv.source_doc_quantity / rdv.total_source_doc_quantity primary_qty, decode(rdv.entered_dr,NULL, rdv.primary_quantity* -1, rdv.primary_quantity) raw_qty, rdv.primary_uom uom, round(rdv.po_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8) primary_unit_price, round(rdv.prior_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8) prior_unit_price, NULL primary_landed_cost, rdv.line_number line_num, rdv.destination_type dest_type, rdv.deliver_to_location deliver_to_location, rdv.currency_code currency_code, NVL(rdv.currency_conversion_rate,1) curr_conv_rate, (rdv.total_source_doc_quantity/rdv.primary_quantity) po_to_pr_uom_rate, rdv.receipt_number receipt_num, rdv.item_revision rev, rdv.category_id cat, rdv.item_description item_des, rdv.transaction_type transaction_type, rdv.organization_id organization_id1, rdv.packing_slip packing_slip, round(rdv.source_doc_quantity, :P_qty_precision) source_doc_quantity, rdv.entered_dr entered_dr, rdv.primary_quantity primary_quantity, pov.vendor_name vendor_name, pov.segment1 vendor_number, decode(:P_sort_id,1,rdv.primary_uom) c_uom, decode(:P_sort_id,1,rdv.item_revision) c_rev, decode(:P_sort_id,1,rdv.item_description ) c_des, decode(:P_sort_id,1,NULL, 2,pov.vendor_name, 3,rdv.receipt_number,1) C_break_column, mp.organization_code to_org, gsob.chart_of_accounts_id coa_id, gsob.currency_code func_currency_code, rdv.accounting_event_id acc_event_id, rdv.event_type_id event_type_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ACC_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_FLEX_ACC_DESC, NULL C_FLEX_ITEM_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price1formula(rdv.accounting_event_id, rdv.transaction_id, round ( rdv.po_unit_price * ( rdv.total_source_doc_quantity / rdv.primary_quantity ) , 8 ), ( rdv.total_source_doc_quantity / rdv.primary_quantity )) C_PRIMARY_UNIT_PRICE1, PO_POXRRVDR_XMLP_PKG.c_sort_main_dispformula(NULL) C_sort_main_disp, PO_POXRRVDR_XMLP_PKG.c_cat_dispformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')) C_cat_disp, PO_POXRRVDR_XMLP_PKG.c_vendorformula(pov.vendor_name) C_vendor, PO_POXRRVDR_XMLP_PKG.c_vendor_numberformula(pov.segment1) C_vendor_number, PO_POXRRVDR_XMLP_PKG.display_column(rdv.deliver_to_location, NULL) C_item_loc_disp, PO_POXRRVDR_XMLP_PKG.price(rdv.entered_dr,round(rdv.po_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8)) C_primary_unit_price, PO_POXRRVDR_XMLP_PKG.calc_trx_value(rdv.currency_code , :C_PRECISION, rdv.event_type_id, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price1formula(rdv.accounting_event_id, rdv.transaction_id, round ( rdv.po_unit_price * ( rdv.total_source_doc_quantity / rdv.primary_quantity ) , 8 ), ( rdv.total_source_doc_quantity / rdv.primary_quantity )), decode(rdv.entered_dr,NULL,rdv.primary_quantity* -1,rdv.primary_quantity) * rdv.source_doc_quantity / rdv.total_source_doc_quantity,NVL(rdv.currency_conversion_rate,1),round(rdv.prior_unit_price * (rdv.total_source_doc_quantity/rdv.primary_quantity), 8), NULL, NULL) C_TRX_VALUE, PO_POXRRVDR_XMLP_PKG.c_quantityformula(rdv.event_type_id, round(decode(rdv.entered_dr,NULL,rdv.primary_quantity* -1,rdv.primary_quantity) * rdv.source_doc_quantity / rdv.total_source_doc_quantity,:P_qty_precision)) C_QUANTITY, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price2formula(rdv.accounting_event_id, PO_POXRRVDR_XMLP_PKG.c_primary_unit_price1formula(rdv.accounting_event_id, rdv.transaction_id, round ( rdv.po_unit_price * ( rdv.total_source_doc_quantity / rdv.primary_quantity ) , 8 ), ( rdv.total_source_doc_quantity / rdv.primary_quantity )) , NULL, NULL, NULL, NVL(rdv.currency_conversion_rate,1) ) C_PRIMARY_UNIT_PRICE2 ,rdv.accounting_line_type FROM rcv_receiving_acct_distr_v rdv , gl_code_combinations gcc , mtl_categories mca , po_vendors pov , mtl_parameters mp , gl_sets_of_books gsob WHERE rdv.item_id is Null AND rdv.actual_flag = 'A' AND :P_ITEM_FROM is NULL AND :P_ITEM_TO is NULL AND gcc.code_combination_id = rdv.code_combination_id AND mca.category_id = rdv.category_id AND exists (select category_set_id from mtl_default_sets_view where functional_area_id = 2 AND category_set_id = :P_cat_set_id) AND &P_WHERE_CAT AND &P_WHERE_ACC AND pov.vendor_id = rdv.vendor_id AND rdv.organization_id = nvl(:P_org_id,rdv.organization_id) AND rdv.organization_id = mp.organization_id AND &P_WHERE_ACCOUNTING_DATE_FROM AND &P_WHERE_ACCOUNTING_DATE_TO AND &P_where_trx_date_from AND &P_where_trx_date_to AND &p_where_vendor AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND gsob.set_of_books_id = rdv.set_of_books_id order by C_dummy_break , C_FLEX_ACC_DISP , coa_id , func_currency_code , C_break_column , primary_qty , prior_unit_price , event_type_id , acc_event_id , po_number , curr_conv_rate , C_FLEX_ITEM_DISP , receipt_num , acct_date , trx_id , primary_quantity , entered_dr , qty , raw_qty , deliver_to_location , currency_code , line_num , transaction_type , dest_type PO POXRRVDR_XML AR PO تقرير توزيع حساب الاستلام (بتنسيق XML) (1) Imported from BI Publisher Description: تقرير توزيع حساب الاستلام Application: المشتريات Source: تقرير توزيع حساب الاستلام (بتنسيق XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG D PO Wareneingang - Buchungsaufteilungen (1) Imported from BI Publisher Description: Wareneingang - Buchungsaufteilungen Application: Einkauf Source: Wareneingang - Buchungsaufteilungen (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG E PO Informe Distribución de Cuentas de Recepción (1) Imported from BI Publisher Description: Informe de distribución de cuentas de recepción Application: Purchasing Source: Informe Distribución de Cuentas de Recepción (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG F PO Etat de la ventilation des comptes de réception (1) Imported from BI Publisher Description: Etat de la ventilation des comptes de réception Application: Purchasing Source: Etat de la ventilation des comptes de réception (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG I PO Rapporto Distribuzione conto di ricezione (1) Imported from BI Publisher Description: Rapporto Distribuzione conto di ricezione Application: Purchasing Source: Rapporto Distribuzione conto di ricezione (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG JA PO 受入勘定科目配分レポート (1) Imported from BI Publisher Description: 受入勘定科目配分レポート Application: Purchasing Source: 受入勘定科目配分レポート(XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG KO PO 입고 계정 분배 보고서 (1) Imported from BI Publisher Description: 입고 계정 분배 보고서 Application: Purchasing Source: 입고 계정 분배 보고서(XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG PTB PO Relatório de Classificação Contábil da Conta de Recebimento (1) Imported from BI Publisher Description: Relatório de Class.Contábil de Contas de Recebimento Application: Compra Source: Relatório de Classificação Contábil da Conta de Recebimento (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG RU PO Отчет о распределении счетов-получателей (1) Imported from BI Publisher Description: Отчет о распределении счетов-получателей Application: Закупки Source: Отчет о распределении счетов-получателей (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG S PO Kontering av inleveranskonto - rapport (1) Imported from BI Publisher Description: Kontering av inleveranskonto - rapport Application: Purchasing Source: Kontering av inleveranskonto - rapport (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG TR PO Teslim Alma Hesap Dağıtımı Raporu (1) Imported from BI Publisher Description: Teslim Alma Hesap Dağıtımı Raporu Application: Satın Alma Yönetimi Source: Teslim Alma Hesap Dağıtımı Raporu (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG US PO Receiving Account Distribution (1) Imported from BI Publisher Description: Receiving Account Distribution Report Application: Purchasing Source: Receiving Account Distribution Report (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG ZHS PO 接收帐户分配报表 (1) Imported from BI Publisher Description: 接收帐户分配报表 Application: 采购管理系统 Source: 接收帐户分配报表 (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG India Localization 1=1 :operating_unit :p_account_from :p_account_to :p_acct_date_from :p_acct_date_from1 :p_acct_date_to :p_acct_date_to1 :p_base_currency :p_cat_set_id :p_cat_set_id1 :p_category_from :p_category_set :p_category_set_id :p_category_to :p_chart_of_accounts_id :p_conc_request_id :p_date_from :p_date_to :p_flex_acc :p_flex_cat :p_flex_item :p_item_from :p_item_to :p_org_displayed :p_org_id :p_qty_precision :p_receipt_num_from :p_receipt_num_to :p_sort_id :p_sort_option :p_struct_num :p_title :p_value_hi :p_value_lo :p_vendor_from :p_vendor_to :p_where_acc :p_where_accounting_date_from :p_where_accounting_date_to :p_where_cat :p_where_item :p_where_receipt_num_from :p_where_receipt_num_to :p_where_trx_date_from :p_where_trx_date_to :p_where_vendor :qty_precision 1 -30 :p_struct_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set Y US Category Structure Structure Number 2 -20 :p_chart_of_accounts_id Number select gsob.chart_of_accounts_id from gl_sets_of_books gsob, financials_system_parameters fsp where fsp.set_of_books_id = gsob.set_of_books_id Y US P_chart_of_accounts Chart of Accounts Id 3 -10 :debugflag Char N US DebugFlag Debug Flag 4 0 :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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 5 10 :p_title Char US Title Title 6 20 :p_sort_option LOV Oracle PO_SRS_POXRRVDR_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('ACCOUNT AND ITEM', 'ACCOUNT AND RECEIPT','ACCOUNT AND VENDOR') order by value,description select displayed_field from po_lookup_codes where lookup_type = 'SRS ORDER BY' and lookup_code = 'ACCOUNT AND ITEM' US Sort Option Sort Option 7 30 :p_org_id LOV Oracle PO_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description US Organization Name Organization 8 40 :p_date_from Date US Date From Accounting Date From 9 50 :p_date_to Date US Date To Accounting Date To 10 60 :p_item_from Char US Item From Items From 11 70 :p_item_to Char US Item to Items To 12 80 :p_category_set LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description select category_set_name from MTL_DEFAULT_SETS_VIEW where FUNCTIONAL_AREA_ID = 2 Y US Category Set Category Set 13 90 :p_category_from Char US Category From Category From 14 100 :p_category_to Char US Category To Category To 15 110 :p_vendor_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name US Vendor From Vendor From 16 120 :p_vendor_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name US Vendor To Vendor To 17 130 :p_receipt_num_from LOV Oracle PO_SRS_RECEIPT_NUMBER Y select rsh.receipt_num id, rsh.receipt_num value, null description from rcv_shipment_headers rsh,po_system_parameters psp,org_organization_definitions ood where rsh.ship_to_org_id=ood.organization_id and ood.operating_unit=psp.org_id and exists ( select 'SHIPMENT HEADER EXISTS' from rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.to_organization_id=:$flex$.po_srs_organizations) order by decode(psp.manual_receipt_num_type, 'NUMERIC', decode(rtrim (rsh.receipt_num,'0123456789'), null,to_number(rsh.receipt_num)), null), decode(psp.manual_receipt_num_type, 'ALPHANUMERIC',rsh.receipt_num) US Receipt Number From Receipt Number From 18 140 :p_receipt_num_to LOV Oracle PO_SRS_RECEIPT_NUMBER Y select rsh.receipt_num id, rsh.receipt_num value, null description from rcv_shipment_headers rsh,po_system_parameters psp,org_organization_definitions ood where rsh.ship_to_org_id=ood.organization_id and ood.operating_unit=psp.org_id and exists ( select 'SHIPMENT HEADER EXISTS' from rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.to_organization_id=:$flex$.po_srs_organizations) order by decode(psp.manual_receipt_num_type, 'NUMERIC', decode(rtrim (rsh.receipt_num,'0123456789'), null,to_number(rsh.receipt_num)), null), decode(psp.manual_receipt_num_type, 'ALPHANUMERIC',rsh.receipt_num) US Receipt Number To Receipt Number To 19 150 :p_account_from Char US Account From Account From 20 160 :p_account_to Char US Account To Account To 21 170 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y US Dynamic Precision Option Quantity Precision