VIEW: APPS.INVFV_SUB_REPLENISH_COUNTS

Source

View Text - Preformatted

SELECT MRH.REPLENISHMENT_HEADER_ID, MRH.REPLENISHMENT_COUNT_NAME, MRH.COUNT_DATE, MRH.ORGANIZATION_ID, MP.ORGANIZATION_CODE, HOU.NAME, MRH.SUBINVENTORY_CODE, MRH.SUPPLY_CUTOFF_DATE, '_LA:MRH.REQUISITION_APPROVAL_TYPE:MFG_LOOKUPS:MTL_REQUISITION_APPROVAL:MEANING', '_LA:MRH.PROCESS_STATUS:MFG_LOOKUPS:MTL_COUNT_STATUS:MEANING', MRH.DELIVERY_LOCATION_ID, HRL.LOCATION_CODE, MRH.CREATED_BY, MRH.CREATION_DATE, MRH.LAST_UPDATED_BY, MRH.LAST_UPDATE_DATE FROM HR_LOCATIONS HRL, HR_ALL_ORGANIZATION_UNITS HOU, MTL_PARAMETERS MP, MTL_REPLENISH_HEADERS MRH WHERE MP.ORGANIZATION_ID = MRH.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MRH.ORGANIZATION_ID AND HRL.LOCATION_ID (+) = MRH.DELIVERY_LOCATION_ID AND '_SEC:MRH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MRH.REPLENISHMENT_HEADER_ID
, MRH.REPLENISHMENT_COUNT_NAME
, MRH.COUNT_DATE
, MRH.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MRH.SUBINVENTORY_CODE
, MRH.SUPPLY_CUTOFF_DATE
, '_LA:MRH.REQUISITION_APPROVAL_TYPE:MFG_LOOKUPS:MTL_REQUISITION_APPROVAL:MEANING'
, '_LA:MRH.PROCESS_STATUS:MFG_LOOKUPS:MTL_COUNT_STATUS:MEANING'
, MRH.DELIVERY_LOCATION_ID
, HRL.LOCATION_CODE
, MRH.CREATED_BY
, MRH.CREATION_DATE
, MRH.LAST_UPDATED_BY
, MRH.LAST_UPDATE_DATE
FROM HR_LOCATIONS HRL
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MP
, MTL_REPLENISH_HEADERS MRH
WHERE MP.ORGANIZATION_ID = MRH.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MRH.ORGANIZATION_ID
AND HRL.LOCATION_ID (+) = MRH.DELIVERY_LOCATION_ID
AND '_SEC:MRH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY