Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_REPLENISH_HEADERS_VIEW |
SELECT MTL_REPLENISH_HEADERS.ROWID
, REPLENISHMENT_HEADER_ID
, REPLENISHMENT_COUNT_NAME
, COUNT_DATE
, MTL_REPLENISH_HEADERS.LAST_UPDATE_DATE
, MTL_REPLENISH_HEADERS.LAST_UPDATED_BY
, MTL_REPLENISH_HEADERS.CREATION_DATE
, MTL_REPLENISH_HEADERS.CREATED_BY
, MTL_REPLENISH_HEADERS.LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, SUPPLY_CUTOFF_DATE
, REQUISITION_APPROVAL_TYPE
, PROCESS_STATUS
, PROCESS_MODE
, ERROR_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DELIVERY_LOCATION_ID
, H.LOCATION_CODE
, MEANING
, COUNT_MODE
, DEFAULT_COUNT_TYPE_CODE
, DEFAULT_LINE_ITEMS
FROM MTL_REPLENISH_HEADERS
, MFG_LOOKUPS
, HR_LOCATIONS_ALL H
WHERE LOOKUP_TYPE = 'MTL_COUNT_STATUS'
AND PROCESS_STATUS = LOOKUP_CODE
AND H.LOCATION_ID (+)= DELIVERY_LOCATION_ID
AND NVL(H.BUSINESS_GROUP_ID
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)