VIEW: APPS.PO_RFQ_LINE_LOCATIONS_PRINT

Source

View Text - Preformatted

SELECT PLL.SHIPMENT_NUM , PLL.SHIPMENT_TYPE , PLL.QUANTITY , PLL.PRICE_OVERRIDE , PLL.LEAD_TIME , PLL.LEAD_TIME_UNIT , PLL.PRICE_DISCOUNT , PLL.START_DATE , PLL.END_DATE , NVL(OFC.FREIGHT_CODE_TL,PLL.SHIP_VIA_LOOKUP_CODE) SHIP_VIA , PLC1.DISPLAYED_FIELD , PLC2.DISPLAYED_FIELD , APT.NAME , PLL.TAXABLE_FLAG , HRL.ADDRESS_LINE_1 , HRL.ADDRESS_LINE_2 , HRL.ADDRESS_LINE_3 , HRL.TOWN_OR_CITY , NVL(HRL.REGION_2,HRL.REGION_1) , HRL.POSTAL_CODE , HRL.COUNTRY , PLL.ATTRIBUTE_CATEGORY , PLL.ATTRIBUTE1 , PLL.ATTRIBUTE2 , PLL.ATTRIBUTE3 , PLL.ATTRIBUTE4 , PLL.ATTRIBUTE5 , PLL.ATTRIBUTE6 , PLL.ATTRIBUTE7 , PLL.ATTRIBUTE8 , PLL.ATTRIBUTE9 , PLL.ATTRIBUTE10 , PLL.ATTRIBUTE11 , PLL.ATTRIBUTE12 , PLL.ATTRIBUTE13 , PLL.ATTRIBUTE14 , PLL.ATTRIBUTE15 , PLL.PO_HEADER_ID , PLL.PO_LINE_ID , PLL.LINE_LOCATION_ID , PLL.SHIP_TO_LOCATION_ID , PLL.NEED_BY_DATE , PLL.ORG_ID FROM PO_LINE_LOCATIONS PLL ,PO_HEADERS_ALL POH ,AP_TERMS APT ,HR_LOCATIONS hrl ,po_lookup_codes plc1 ,po_lookup_codes plc2 , ORG_FREIGHT OFC WHERE PLL.SHIP_TO_LOCATION_ID =HRL.LOCATION_ID(+) AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID AND PLL.TERMS_ID = APT.TERM_ID (+) AND POH.TYPE_LOOKUP_CODE = 'RFQ' AND PLL.SHIPMENT_TYPE = 'RFQ' AND PLC1.LOOKUP_CODE(+) = PLL.FOB_LOOKUP_CODE AND PLC1.LOOKUP_TYPE(+) = 'FOB' AND PLC2.LOOKUP_CODE(+) = PLL.FREIGHT_TERMS_LOOKUP_CODE AND PLC2.LOOKUP_TYPE(+) = 'FREIGHT TERMS' AND OFC.FREIGHT_CODE (+) = PLL.SHIP_VIA_LOOKUP_CODE AND OFC.ORGANIZATION_ID (+) = PLL.ORG_ID

View Text - HTML Formatted

SELECT PLL.SHIPMENT_NUM
, PLL.SHIPMENT_TYPE
, PLL.QUANTITY
, PLL.PRICE_OVERRIDE
, PLL.LEAD_TIME
, PLL.LEAD_TIME_UNIT
, PLL.PRICE_DISCOUNT
, PLL.START_DATE
, PLL.END_DATE
, NVL(OFC.FREIGHT_CODE_TL
, PLL.SHIP_VIA_LOOKUP_CODE) SHIP_VIA
, PLC1.DISPLAYED_FIELD
, PLC2.DISPLAYED_FIELD
, APT.NAME
, PLL.TAXABLE_FLAG
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, HRL.TOWN_OR_CITY
, NVL(HRL.REGION_2
, HRL.REGION_1)
, HRL.POSTAL_CODE
, HRL.COUNTRY
, PLL.ATTRIBUTE_CATEGORY
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE10
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIP_TO_LOCATION_ID
, PLL.NEED_BY_DATE
, PLL.ORG_ID
FROM PO_LINE_LOCATIONS PLL
, PO_HEADERS_ALL POH
, AP_TERMS APT
, HR_LOCATIONS HRL
, PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
, ORG_FREIGHT OFC
WHERE PLL.SHIP_TO_LOCATION_ID =HRL.LOCATION_ID(+)
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.TERMS_ID = APT.TERM_ID (+)
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND PLL.SHIPMENT_TYPE = 'RFQ'
AND PLC1.LOOKUP_CODE(+) = PLL.FOB_LOOKUP_CODE
AND PLC1.LOOKUP_TYPE(+) = 'FOB'
AND PLC2.LOOKUP_CODE(+) = PLL.FREIGHT_TERMS_LOOKUP_CODE
AND PLC2.LOOKUP_TYPE(+) = 'FREIGHT TERMS'
AND OFC.FREIGHT_CODE (+) = PLL.SHIP_VIA_LOOKUP_CODE
AND OFC.ORGANIZATION_ID (+) = PLL.ORG_ID