INV Item replenishment count

Description

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

INV Item replenishment count and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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