VIEW: APPS.PO_LINE_LOCATIONS_RFQQT_V

Source

View Text - Preformatted

SELECT PLL.ROWID , PLL.PO_HEADER_ID , PLL.PO_LINE_ID , PLL.LINE_LOCATION_ID , PLL.SHIPMENT_NUM , PLL.SHIPMENT_TYPE , PLL.SHIP_TO_ORGANIZATION_ID , OOD.ORGANIZATION_CODE , OOD.ORGANIZATION_NAME , PLL.SHIP_TO_LOCATION_ID , HRL.LOCATION_CODE , PLL.QUANTITY , PLL.UNIT_MEAS_LOOKUP_CODE , PLL.PRICE_OVERRIDE , PLL.LAST_ACCEPT_DATE , PLL.NEED_BY_DATE , PLL.FIRM_STATUS_LOOKUP_CODE , PLL.PRICE_DISCOUNT , PLL.START_DATE , PLL.END_DATE , PLL.LEAD_TIME , PLL.LEAD_TIME_UNIT , PLL.TERMS_ID , APT.NAME , PLL.FREIGHT_TERMS_LOOKUP_CODE , PLL.FOB_LOOKUP_CODE , PLL.SHIP_VIA_LOOKUP_CODE , NULL , PLL.TAXABLE_FLAG , PLL.INSPECTION_REQUIRED_FLAG , PLL.RECEIPT_REQUIRED_FLAG , PLL.RECEIVE_CLOSE_TOLERANCE , PLL.QTY_RCV_EXCEPTION_CODE , POH.QUOTE_TYPE_LOOKUP_CODE , PLL.FROM_HEADER_ID , PLL.FROM_LINE_ID , PLL.FROM_LINE_LOCATION_ID , PLL.LAST_UPDATE_DATE , PLL.LAST_UPDATED_BY , PLL.LAST_UPDATE_LOGIN , PLL.CREATED_BY , PLL.CREATION_DATE , PLL.PROGRAM_ID , PLL.REQUEST_ID , PLL.PROGRAM_APPLICATION_ID , PLL.PROGRAM_UPDATE_DATE , 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.ATTRIBUTE_CATEGORY , PLL.TAX_CODE_ID , PLL.ORG_ID FROM PO_LINE_LOCATIONS PLL, PO_HEADERS_ALL POH, HR_LOCATIONS_ALL_TL HRL, ORG_ORGANIZATION_DEFINITIONS OOD, AP_TERMS APT WHERE HRL.LOCATION_ID (+) = PLL.SHIP_TO_LOCATION_ID AND HRL.LANGUAGE (+) = USERENV('LANG') AND OOD.ORGANIZATION_ID(+) = PLL.SHIP_TO_ORGANIZATION_ID AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID AND POH.TYPE_LOOKUP_CODE IN ('RFQ', 'QUOTATION') AND APT.TERM_ID (+) = PLL.TERMS_ID

View Text - HTML Formatted

SELECT PLL.ROWID
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, PLL.SHIPMENT_TYPE
, PLL.SHIP_TO_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME
, PLL.SHIP_TO_LOCATION_ID
, HRL.LOCATION_CODE
, PLL.QUANTITY
, PLL.UNIT_MEAS_LOOKUP_CODE
, PLL.PRICE_OVERRIDE
, PLL.LAST_ACCEPT_DATE
, PLL.NEED_BY_DATE
, PLL.FIRM_STATUS_LOOKUP_CODE
, PLL.PRICE_DISCOUNT
, PLL.START_DATE
, PLL.END_DATE
, PLL.LEAD_TIME
, PLL.LEAD_TIME_UNIT
, PLL.TERMS_ID
, APT.NAME
, PLL.FREIGHT_TERMS_LOOKUP_CODE
, PLL.FOB_LOOKUP_CODE
, PLL.SHIP_VIA_LOOKUP_CODE
, NULL
, PLL.TAXABLE_FLAG
, PLL.INSPECTION_REQUIRED_FLAG
, PLL.RECEIPT_REQUIRED_FLAG
, PLL.RECEIVE_CLOSE_TOLERANCE
, PLL.QTY_RCV_EXCEPTION_CODE
, POH.QUOTE_TYPE_LOOKUP_CODE
, PLL.FROM_HEADER_ID
, PLL.FROM_LINE_ID
, PLL.FROM_LINE_LOCATION_ID
, PLL.LAST_UPDATE_DATE
, PLL.LAST_UPDATED_BY
, PLL.LAST_UPDATE_LOGIN
, PLL.CREATED_BY
, PLL.CREATION_DATE
, PLL.PROGRAM_ID
, PLL.REQUEST_ID
, PLL.PROGRAM_APPLICATION_ID
, PLL.PROGRAM_UPDATE_DATE
, 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.ATTRIBUTE_CATEGORY
, PLL.TAX_CODE_ID
, PLL.ORG_ID
FROM PO_LINE_LOCATIONS PLL
, PO_HEADERS_ALL POH
, HR_LOCATIONS_ALL_TL HRL
, ORG_ORGANIZATION_DEFINITIONS OOD
, AP_TERMS APT
WHERE HRL.LOCATION_ID (+) = PLL.SHIP_TO_LOCATION_ID
AND HRL.LANGUAGE (+) = USERENV('LANG')
AND OOD.ORGANIZATION_ID(+) = PLL.SHIP_TO_ORGANIZATION_ID
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POH.TYPE_LOOKUP_CODE IN ('RFQ'
, 'QUOTATION')
AND APT.TERM_ID (+) = PLL.TERMS_ID