View: POS_SHIPMENTS_V

Product:	PO - Purchasing
Description:	Create ASN View
Implementation/DBA Data:	APPS.POS_SHIPMENTS_V

View Text

SELECT DECODE(PRL.PO_RELEASE_ID
, NULL
, POH.SEGMENT1
, POH.SEGMENT1 || '-' || TO_CHAR(PRL.RELEASE_NUM)) PO_NUMBER
, POH.PO_HEADER_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.VENDOR_CONTACT_ID
, POL.LINE_NUM
, POV.VENDOR_NAME
, POL.ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUM
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.VENDOR_PRODUCT_NUM SUPPLIER_ITEM_NUMBER
, POL.UNIT_PRICE
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE) DUE_DATE
, POL.UNIT_MEAS_LOOKUP_CODE
, POS_CREATE_ASN.GETAVAILABLESHIPMENTQUANTITY(PLL.LINE_LOCATION_ID) SHIPMENT_QUANTITY
, POS_CREATE_ASN.GETTOLERABLESHIPMENTQUANTITY(PLL.LINE_LOCATION_ID) TOLERABLE_QUANTITY
, PLL.QUANTITY QUANTITY_ORDERED
, PLL.QUANTITY_RECEIVED
, HRL.LOCATION_CODE SHIP_TO_LOCATION
, PVS.VENDOR_SITE_CODE
, PVS.PAY_SITE_FLAG
, POH.CURRENCY_CODE
, POH.RATE_TYPE
, POH.RATE
, POH.RATE_DATE
, POL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIP_TO_ORGANIZATION_ID ORG_ID
, PLL.SHIPMENT_NUM
, NVL(PLL.QTY_RCV_EXCEPTION_CODE
, 'NONE') QTY_RCV_EXCEPTION_CODE
, PLL.TAXABLE_FLAG
, PLL.TAX_NAME
, PLL.ESTIMATED_TAX_AMOUNT
, POH.REVISION_NUM
, MTP.ORGANIZATION_CODE
, HRO.NAME ORGANIZATION_NAME
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL PLL
, PO_RELEASES_ALL PRL
, PO_VENDOR_SITES_ALL PVS
, HR_LOCATIONS_ALL HRL
, PO_VENDORS POV
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MTP
, HR_ALL_ORGANIZATION_UNITS_TL HRO
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POH.AUTHORIZATION_STATUS = 'APPROVED'
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+)
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND HRL.LOCATION_ID = POH.SHIP_TO_LOCATION_ID
AND PLL.APPROVED_FLAG ='Y'
AND NVL(PLL.CLOSED_CODE
, 'OPEN')<> 'FINALLY CLOSED'
AND PLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND NVL(MSI.ORGANIZATION_ID
, PLL.SHIP_TO_ORGANIZATION_ID) = PLL.SHIP_TO_ORGANIZATION_ID
AND MTP.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID
AND HRO.ORGANIZATION_ID = POH.ORG_ID
AND HRO.LANGUAGE = USERENV('LANG')

Columns