INV Item replenishment count
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item replenishment count report
Application: Inventory
Source: Item replenishment count report (XML)
Short Name: INVIRRCR_XML
DB package: INV_INVIRRCR_XMLP_PKG
Description: Item replenishment count report
Application: Inventory
Source: Item replenishment count report (XML)
Short Name: INVIRRCR_XML
DB package: INV_INVIRRCR_XMLP_PKG
Run
INV Item replenishment count and other Oracle EBS reports with Blitz Report™ on our demo environment
select mrh.replenishment_count_name CountName, mrh.subinventory_code , mrh.Count_Date, mfg3.meaning ProcessStatus, mrh.supply_cutoff_date, mrl.inventory_item_id item_id, mfg2.meaning count_type, mrl.primary_uom_code uom, nvl(mrl.primary_uom_count_quantity,0) count_qty, nvl(mrl.supply_quantity,0) supply_qty, nvl(mrl.reorder_quantity,0) reorder_qty, mfg1.meaning source_type, decode(mrl.source_organization_id, null,'',orgs.organization_code) source_organization, mrl.source_subinventory source_subinventory, mfg.meaning error_message, mrl.error_flag error_code, mrl.expense_account ExpenseAccount_Flexid, null ExpenseAccount_Flexdat, &P_ITEM_FLEXSQL C_ITEM_FLEXDAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_item_flexval', 'INV', 'MSTK', 101, SYS.ORGANIZATION_ID, SYS.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') F_Item_FlexVal, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_expenseaccount_flex', 'SQLGL', 'GL#', GLC_1.CHART_OF_ACCOUNTS_ID, NULL, GLC_1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_ExpenseAccount_Flex from mfg_lookups mfg, mfg_lookups mfg1, mfg_lookups mfg2, mfg_lookups mfg3, org_organization_definitions orgs, mtl_system_items sys, mtl_replenish_lines mrl, gl_code_combinations glc_1, mtl_replenish_headers mrh where sys.organization_id = :P_ORG_ID and mrl.organization_id = :P_ORG_ID and mrl.replenishment_header_id = :P_HeaderID and sys.inventory_item_id = mrl.inventory_item_id and mrl.error_flag = mfg.lookup_code(+) and mfg.lookup_type(+) = 'MTL_REPLENISHMENT_ERROR' and mrl.source_type = mfg1.lookup_code(+) and mfg1.lookup_type(+) = 'MTL_SOURCE_TYPES' and mrl.source_organization_id = orgs.organization_id (+) and mfg2.lookup_type = 'MTL_COUNT_TYPES' and mfg2.lookup_code = mrl.count_type_code and mrl.expense_account = glc_1.code_combination_id (+) and mrh.organization_id = :P_ORG_ID and mrh.replenishment_header_id = :P_HeaderID and mrh.process_status = mfg3.lookup_code and mfg3.lookup_type = 'MTL_COUNT_STATUS' ORDER BY 19 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Count Name |
|
LOV Oracle |