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_HEADERS_V

Source

View Text - Preformatted


SELECT 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.DISPLAYED_FIELD, PLC.LOOKUP_CODE, ASNH.PACKING_SLIP, ASNH.CURRENCY_CODE, ASNH.CURRENCY_CONVERSION_RATE, ASNH.CURRENCY_CONVERSION_DATE, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.NUM_OF_CONTAINERS), ASNH.CARRIER_EQUIPMENT, ASNH.CARRIER_METHOD, ASNH.FREIGHT_BILL_NUMBER, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.GROSS_WEIGHT), UM1.UNIT_OF_MEASURE, ASNH.GROSS_WEIGHT_UOM_CODE, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.NET_WEIGHT), UM2.UNIT_OF_MEASURE, ASNH.NET_WEIGHT_UOM_CODE, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.TAR_WEIGHT), UM3.UNIT_OF_MEASURE, ASNH.TAR_WEIGHT_UOM_CODE, ASNH.PACKAGING_CODE, ASNH.SPECIAL_HANDLING_CODE, ASNH.INVOICE_NUM, ASNH.TOTAL_INVOICE_AMOUNT, NVL(ASNH.INVOICE_DATE,FND_DATE.DATE_TO_CHARDATE(SYSDATE)) , ASNH.FREIGHT_AMOUNT, ASNH.TAX_NAME, ASNH.TAX_AMOUNT, ATV.NAME, ASNH.SESSION_ID, ASNH.SHIP_TO_ORGANIZATION_ID FROM POS_ASN_SHOP_CART_HEADERS ASNH, PO_VENDORS POV, PO_VENDOR_SITES PVS, AP_TERMS_VAL_V ATV, MTL_UNITS_OF_MEASURE UM1, MTL_UNITS_OF_MEASURE UM2, MTL_UNITS_OF_MEASURE UM3, PO_LOOKUP_CODES PLC, 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 POS_HEADER_INFO_S.GETPAYMENTTERMS(ASNH.SESSION_ID, ASNH.VENDOR_SITE_ID) = ATV.TERM_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 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 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.DISPLAYED_FIELD
, PLC.LOOKUP_CODE
, ASNH.PACKING_SLIP
, ASNH.CURRENCY_CODE
, ASNH.CURRENCY_CONVERSION_RATE
, ASNH.CURRENCY_CONVERSION_DATE
, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.NUM_OF_CONTAINERS)
, ASNH.CARRIER_EQUIPMENT
, ASNH.CARRIER_METHOD
, ASNH.FREIGHT_BILL_NUMBER
, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.GROSS_WEIGHT)
, UM1.UNIT_OF_MEASURE
, ASNH.GROSS_WEIGHT_UOM_CODE
, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.NET_WEIGHT)
, UM2.UNIT_OF_MEASURE
, ASNH.NET_WEIGHT_UOM_CODE
, FND_NUMBER.NUMBER_TO_CANONICAL(ASNH.TAR_WEIGHT)
, UM3.UNIT_OF_MEASURE
, ASNH.TAR_WEIGHT_UOM_CODE
, ASNH.PACKAGING_CODE
, ASNH.SPECIAL_HANDLING_CODE
, ASNH.INVOICE_NUM
, ASNH.TOTAL_INVOICE_AMOUNT
, NVL(ASNH.INVOICE_DATE
, FND_DATE.DATE_TO_CHARDATE(SYSDATE))
, ASNH.FREIGHT_AMOUNT
, ASNH.TAX_NAME
, ASNH.TAX_AMOUNT
, ATV.NAME
, ASNH.SESSION_ID
, ASNH.SHIP_TO_ORGANIZATION_ID
FROM POS_ASN_SHOP_CART_HEADERS ASNH
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, AP_TERMS_VAL_V ATV
, MTL_UNITS_OF_MEASURE UM1
, MTL_UNITS_OF_MEASURE UM2
, MTL_UNITS_OF_MEASURE UM3
, PO_LOOKUP_CODES PLC
, 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 POS_HEADER_INFO_S.GETPAYMENTTERMS(ASNH.SESSION_ID
, ASNH.VENDOR_SITE_ID) = ATV.TERM_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 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(+)