Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVFV_ITEM_REPLENISH_COUNTS |
SELECT MRL.REPLENISHMENT_LINE_ID
, MRL.REPLENISHMENT_HEADER_ID
, MRH.REPLENISHMENT_COUNT_NAME
, MRL.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MRL.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ '_LA:MRL.COUNT_TYPE_CODE:MFG_LOOKUPS:MTL_COUNT_TYPES:MEANING'
, /* LOOKUP */ MRL.COUNT_QUANTITY
, MRL.COUNT_UOM_CODE
, MRL.REFERENCE
, '_LA:MRL.ERROR_FLAG:MFG_LOOKUPS:MTL_REPLENISHMENT_ERROR:MEANING'
, /* LOOKUP */ MRL.PRIMARY_UOM_COUNT_QUANTITY
, MRL.PRIMARY_UOM_CODE
, MRL.CREATED_BY
, MRL.CREATION_DATE
, MRL.LAST_UPDATED_BY
, MRL.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_SYSTEM_ITEMS MSI
, MTL_REPLENISH_HEADERS MRH
, MTL_REPLENISH_LINES MRL
WHERE MP.ORGANIZATION_ID = MRL.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MRL.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MRL.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MRL.INVENTORY_ITEM_ID
AND MRH.REPLENISHMENT_HEADER_ID = MRL.REPLENISHMENT_HEADER_ID
AND '_SEC:MRL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY