View: POS_UPD_DATE_PO_SHIP_V

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.POS_UPD_DATE_PO_SHIP_V

View Text

SELECT POH.PO_HEADER_ID
, DECODE(PRL.PO_RELEASE_ID
, NULL
, POH.SEGMENT1
, POH.SEGMENT1 || '-' || TO_CHAR(PRL.RELEASE_NUM)) PO_NUMBER
, PRL.PO_RELEASE_ID
, POL.PO_LINE_ID
, POL.LINE_NUM
, POLL.LINE_LOCATION_ID
, POLL.SHIPMENT_NUM
, POLL.SHIP_TO_LOCATION_ID
, HRT.LOCATION_CODE
, POL.VENDOR_PRODUCT_NUM
, POL.ITEM_DESCRIPTION
, POLL.QUANTITY
, NVL(POLL.UNIT_MEAS_LOOKUP_CODE
, POL.UNIT_MEAS_LOOKUP_CODE)
, NVL(POLL.PROMISED_DATE
, POLL.NEED_BY_DATE)
, POH.VENDOR_ID
, VEN.VENDOR_NAME
, POH.VENDOR_SITE_ID
, VST.VENDOR_SITE_CODE
, POLL.SHIP_TO_ORGANIZATION_ID
, STO.ORGANIZATION_CODE
, STO.ORGANIZATION_NAME
, POL.ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, POL.ITEM_REVISION
, POL.CATEGORY_ID
, MCT.CONCATENATED_SEGMENTS
, POLL.PROMISED_DATE
, POLL.NEED_BY_DATE
, POLL.QUANTITY_RECEIVED
, POLL.QUANTITY_SHIPPED
, POH.REVISION_NUM
, POLL.CHANGE_PROMISED_DATE_REASON
, POLL.PROMISED_DATE
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(POH.AGENT_ID)
FROM PO_HEADERS POH
, PO_LINES POL
, PO_RELEASES PRL
, PO_LINE_LOCATIONS POLL
, HR_LOCATIONS HRT
, PO_VENDORS VEN
, PO_VENDOR_SITES VST
, ORG_ORGANIZATION_DEFINITIONS STO
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_CATEGORIES_KFV MCT
WHERE POLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND POLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+)
AND POLL.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID
AND POH.VENDOR_ID = VEN.VENDOR_ID
AND POH.VENDOR_SITE_ID = VST.VENDOR_SITE_ID
AND NVL(POH.ORG_ID
, -1) = NVL( VST.ORG_ID
, -1)
AND POLL.SHIP_TO_ORGANIZATION_ID = STO.ORGANIZATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND NVL(MSI.ORGANIZATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID
AND POL.CATEGORY_ID = MCT.CATEGORY_ID
AND NVL(POLL.APPROVED_FLAG
, 'N') = 'Y'
AND NVL(POLL.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POLL.CLOSED_CODE
, 'OPEN') = 'OPEN'
AND POLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND POH.AUTHORIZATION_STATUS <> 'IN PROCESS' ORDER BY PO_HEADER_ID
, PO_NUMBER
, LINE_NUM
, SHIPMENT_NUM

Columns