View: POS_ASN_REVIEW_HEADERS_V

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

View Text

SELECT PLC1.DESCRIPTION
, NVL(ASNH.TRANSACTION_TYPE
, PLC1.LOOKUP_CODE)
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, HRT.LOCATION_CODE
, HOUT.NAME
, ASNH.SHIPMENT_NUM
, ASNH.BILL_OF_LADING
, ASNH.WAYBILL_AIRBILL_NUM
, NVL(ASNH.SHIP_DATE
, FND_DATE.DATE_TO_CHARDATE(SYSDATE))
, ASNH.EXPECTED_RECEIPT_DATE
, ASNH.COMMENTS
, OFG.DESCRIPTION
, ASNH.FREIGHT_CARRIER_CODE
, PLC.DESCRIPTION
, ASNH.PACKING_SLIP
, ASNH.CURRENCY_CODE
, ASNH.CURRENCY_CONVERSION_RATE
, ASNH.CURRENCY_CONVERSION_DATE
, ASNH.NUM_OF_CONTAINERS
, ASNH.CARRIER_EQUIPMENT
, ASNH.CARRIER_METHOD
, ASNH.FREIGHT_BILL_NUMBER
, ASNH.GROSS_WEIGHT
, UM1.DESCRIPTION
, ASNH.GROSS_WEIGHT_UOM_CODE
, ASNH.NET_WEIGHT
, UM2.DESCRIPTION
, ASNH.NET_WEIGHT_UOM_CODE
, ASNH.TAR_WEIGHT
, UM3.DESCRIPTION
, ASNH.TAR_WEIGHT_UOM_CODE
, ASNH.PACKAGING_CODE
, ASNH.SPECIAL_HANDLING_CODE
, ASNH.INVOICE_NUM
, ASNH.TOTAL_INVOICE_AMOUNT
, ASNH.INVOICE_DATE
, ASNH.FREIGHT_AMOUNT
, ASNH.TAX_NAME
, ASNH.TAX_AMOUNT
, ASNH.PAYMENT_TERMS
, ASNH.SESSION_ID
FROM POS_ASN_SHOP_CART_HEADERS ASNH
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, MTL_UNITS_OF_MEASURE UM1
, MTL_UNITS_OF_MEASURE UM2
, MTL_UNITS_OF_MEASURE UM3
, PO_LOOKUP_CODES PLC
, PO_LOOKUP_CODES PLC1
, ORG_FREIGHT OFG
, HR_ORG_UNITS_NO_JOIN HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_LOCATIONS HRT
WHERE ASNH.VENDOR_ID = POV.VENDOR_ID
AND ASNH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND ASNH.GROSS_WEIGHT_UOM_CODE = UM1.UOM_CODE(+)
AND ASNH.NET_WEIGHT_UOM_CODE = UM2.UOM_CODE(+)
AND ASNH.TAR_WEIGHT_UOM_CODE = UM3.UOM_CODE(+)
AND PLC.LOOKUP_TYPE(+) = 'FREIGHT TERMS'
AND ASNH.FREIGHT_TERMS = PLC.LOOKUP_CODE(+)
AND PLC1.LOOKUP_TYPE = 'TRANSACTION_TYPE'
AND PLC1.LOOKUP_CODE = 'NEW'
AND ASNH.FREIGHT_CARRIER_CODE = OFG.FREIGHT_CODE(+)
AND ASNH.SHIP_TO_ORGANIZATION_ID = OFG.ORGANIZATION_ID(+)
AND ASNH.SHIP_TO_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID (+)
AND DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, HOUT.LANGUAGE) = DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, USERENV( 'LANG'))
AND ASNH.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID(+)

Columns