VIEW: APPS.MTL_REPLENISH_HEADERS_VIEW

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)