VIEW: APPS.POS_ASN_SHIPMENT_DETAILS_V

Source

View Text - Preformatted

SELECT ASND.SESSION_ID, ASND.ASN_LINE_ID, ASND.SHIP_TO_ORGANIZATION_ID, ASND.PO_LINE_LOCATION_ID, ASND.EXPECTED_RECEIPT_DATE, ASND.WAYBILL_AIRBILL_NUM, ASND.BARCODE_LABEL, ASND.BILL_OF_LADING, ASND.CONTAINER_NUM, ASND.COUNTRY_OF_ORIGIN_CODE, FT.TERRITORY_SHORT_NAME, ASND.VENDOR_CUM_SHIPPED_QTY, OFG.DESCRIPTION, ASND.FREIGHT_CARRIER_CODE, ASND.NUM_OF_CONTAINERS, ASND.PACKING_SLIP, ASND.REASON_ID, MTR.REASON_NAME, HRT.LOCATION_CODE, ASND.VENDOR_LOT_NUM, ASND.TRUCK_NUM, MCA.CONCATENATED_SEGMENTS, POL.ITEM_REVISION, POL.ITEM_DESCRIPTION, POL.LINE_NUM, POH.SEGMENT1 || DECODE(POR.RELEASE_NUM, NULL, NULL, '-' || TO_CHAR(POR.RELEASE_NUM)), PLL.SHIPMENT_NUM, POV.VENDOR_NAME, PVS.VENDOR_SITE_CODE, ASND.ACTUAL_COST, ASND.TRANSFER_COST, ASND.TRANSPORTATION_COST, ASND.RMA_REFERENCE, ASND.TRANSPORTATION_ACCOUNT_ID, ASND.UNIT_OF_MEASURE, ASND.UOM_CODE, ASND.QUANTITY_INVOICED, POL.UNIT_PRICE, ASND.NOTICE_UNIT_PRICE, ASND.QUANTITY_INVOICED*POL.UNIT_PRICE, PLL.TAXABLE_FLAG, APT.NAME, APT.TAX_RATE, POH.CURRENCY_CODE, POH.RATE_TYPE, POH.RATE_DATE, POH.RATE, ASND.ASN_LINE_SPLIT_ID FROM POS_ASN_SHOP_CART_DETAILS ASND, PO_LINE_LOCATIONS PLL, PO_LINES POL, PO_RELEASES POR, PO_HEADERS POH, PO_VENDORS POV, PO_VENDOR_SITES PVS, HR_LOCATIONS HRT, ORG_FREIGHT OFG, MTL_CATEGORIES_KFV MCA, FND_TERRITORIES_TL FT, MTL_TRANSACTION_REASONS MTR, AP_TAX_CODES APT WHERE ASND.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND ASND.PO_HEADER_ID = POH.PO_HEADER_ID AND ASND.PO_LINE_ID = POL.PO_LINE_ID AND POH.VENDOR_ID = POV.VENDOR_ID AND POH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID AND PLL.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID (+) AND ASND.FREIGHT_CARRIER_CODE = OFG.FREIGHT_CODE(+) AND ASND.SHIP_TO_ORGANIZATION_ID = OFG.ORGANIZATION_ID(+) AND POL.CATEGORY_ID = MCA.CATEGORY_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.PO_RELEASE_ID = POR.PO_RELEASE_ID(+) AND PLL.TAX_CODE_ID = APT.TAX_ID(+)

View Text - HTML Formatted

SELECT ASND.SESSION_ID
, ASND.ASN_LINE_ID
, ASND.SHIP_TO_ORGANIZATION_ID
, ASND.PO_LINE_LOCATION_ID
, ASND.EXPECTED_RECEIPT_DATE
, ASND.WAYBILL_AIRBILL_NUM
, ASND.BARCODE_LABEL
, ASND.BILL_OF_LADING
, ASND.CONTAINER_NUM
, ASND.COUNTRY_OF_ORIGIN_CODE
, FT.TERRITORY_SHORT_NAME
, ASND.VENDOR_CUM_SHIPPED_QTY
, OFG.DESCRIPTION
, ASND.FREIGHT_CARRIER_CODE
, ASND.NUM_OF_CONTAINERS
, ASND.PACKING_SLIP
, ASND.REASON_ID
, MTR.REASON_NAME
, HRT.LOCATION_CODE
, ASND.VENDOR_LOT_NUM
, ASND.TRUCK_NUM
, MCA.CONCATENATED_SEGMENTS
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.LINE_NUM
, POH.SEGMENT1 || DECODE(POR.RELEASE_NUM
, NULL
, NULL
, '-' || TO_CHAR(POR.RELEASE_NUM))
, PLL.SHIPMENT_NUM
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, ASND.ACTUAL_COST
, ASND.TRANSFER_COST
, ASND.TRANSPORTATION_COST
, ASND.RMA_REFERENCE
, ASND.TRANSPORTATION_ACCOUNT_ID
, ASND.UNIT_OF_MEASURE
, ASND.UOM_CODE
, ASND.QUANTITY_INVOICED
, POL.UNIT_PRICE
, ASND.NOTICE_UNIT_PRICE
, ASND.QUANTITY_INVOICED*POL.UNIT_PRICE
, PLL.TAXABLE_FLAG
, APT.NAME
, APT.TAX_RATE
, POH.CURRENCY_CODE
, POH.RATE_TYPE
, POH.RATE_DATE
, POH.RATE
, ASND.ASN_LINE_SPLIT_ID
FROM POS_ASN_SHOP_CART_DETAILS ASND
, PO_LINE_LOCATIONS PLL
, PO_LINES POL
, PO_RELEASES POR
, PO_HEADERS POH
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, HR_LOCATIONS HRT
, ORG_FREIGHT OFG
, MTL_CATEGORIES_KFV MCA
, FND_TERRITORIES_TL FT
, MTL_TRANSACTION_REASONS MTR
, AP_TAX_CODES APT
WHERE ASND.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND ASND.PO_HEADER_ID = POH.PO_HEADER_ID
AND ASND.PO_LINE_ID = POL.PO_LINE_ID
AND POH.VENDOR_ID = POV.VENDOR_ID
AND POH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND PLL.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID (+)
AND ASND.FREIGHT_CARRIER_CODE = OFG.FREIGHT_CODE(+)
AND ASND.SHIP_TO_ORGANIZATION_ID = OFG.ORGANIZATION_ID(+)
AND POL.CATEGORY_ID = MCA.CATEGORY_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.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
AND PLL.TAX_CODE_ID = APT.TAX_ID(+)