eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.POS_ASN_REVIEW_HEADERS_V

Source

View Text - Preformatted


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(+)

View Text - HTML Formatted

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(+)