Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_ITEM_REPLENISH_COUNTS |
SELECT MRL.REPLENISHMENT_LINE_ID
, MRL.REPLENISHMENT_HEADER_ID
, MRL.ORGANIZATION_ID
, MRL.INVENTORY_ITEM_ID
, '_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_REPLENISH_LINES MRL
WHERE '_SEC:MRL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY