View: POS_ASN_REVIEW_SHIPMENTS_V

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

View Text

SELECT ASND.SESSION_ID
, TO_CHAR(ASND.ASN_LINE_ID) || DECODE(ASND.ASN_LINE_SPLIT_ID
, 0
, ''
, '-' || TO_CHAR(ASND.ASN_LINE_SPLIT_ID))
, ASND.ASN_LINE_ID
, ASND.ASN_LINE_SPLIT_ID
, ASND.PO_LINE_LOCATION_ID
, ASND.QUANTITY_SHIPPED
, ASND.UNIT_OF_MEASURE
, ASND.EXPECTED_RECEIPT_DATE
, ASND.COMMENTS
, MSI.CONCATENATED_SEGMENTS
, POL.ITEM_DESCRIPTION
, POL.VENDOR_PRODUCT_NUM
, DECODE(PRL.PO_RELEASE_ID
, NULL
, POH.SEGMENT1
, POH.SEGMENT1 || '-' || TO_CHAR(PRL.RELEASE_NUM))
, NVL(PLL.NEED_BY_DATE
, PLL.PROMISED_DATE)
, POL.LINE_NUM
, PLL.SHIPMENT_NUM
, HRT.LOCATION_CODE
, ASND.VENDOR_CUM_SHIPPED_QTY
, ASND.PACKING_SLIP
, ASND.BARCODE_LABEL
, ASND.WAYBILL_AIRBILL_NUM
, ASND.BILL_OF_LADING
, ASND.CONTAINER_NUM
, ASND.NUM_OF_CONTAINERS
, ASND.TRUCK_NUM
, FT.TERRITORY_SHORT_NAME
, OFG.DESCRIPTION
, ASND.VENDOR_LOT_NUM
, MTR.REASON_NAME
, ASND.QUANTITY_INVOICED
, ASND.NOTICE_UNIT_PRICE
, ASND.QUANTITY_INVOICED*POL.UNIT_PRICE
, PLL.TAXABLE_FLAG
, APT.NAME
, APT.TAX_RATE
FROM POS_ASN_SHOP_CART_DETAILS ASND
, PO_HEADERS POH
, PO_LINES POL
, PO_LINE_LOCATIONS PLL
, PO_RELEASES PRL
, MTL_SYSTEM_ITEMS_KFV MSI
, ORG_FREIGHT OFG
, HR_LOCATIONS HRT
, FND_TERRITORIES_TL FT
, MTL_TRANSACTION_REASONS MTR
, AP_TAX_CODES APT
WHERE ASND.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND PLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+)
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND NVL(MSI.ORGANIZATION_ID
, PLL.SHIP_TO_ORGANIZATION_ID) = PLL.SHIP_TO_ORGANIZATION_ID
AND ASND.FREIGHT_CARRIER_CODE = OFG.FREIGHT_CODE(+)
AND ASND.SHIP_TO_ORGANIZATION_ID = OFG.ORGANIZATION_ID(+)
AND PLL.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID (+)
AND ASND.COUNTRY_OF_ORIGIN_CODE = FT.TERRITORY_CODE(+)
AND NVL(FT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND ASND.REASON_ID = MTR.REASON_ID(+)
AND PLL.TAX_CODE_ID = APT.TAX_ID(+) ORDER BY ASND.ASN_LINE_ID
, ASND.ASN_LINE_SPLIT_ID

Columns