VIEW: APPS.PO_ITEM_SOURCES

Source

View Text - Preformatted

SELECT LL.LINE_LOCATION_ID , LL.PO_LINE_ID , LL.PO_HEADER_ID , H.SEGMENT1 , L.LINE_NUM , L.LINE_TYPE_ID , H.VENDOR_ID , H.VENDOR_SITE_ID , H.VENDOR_CONTACT_ID , L.LAST_UPDATE_DATE , L.LAST_UPDATED_BY , L.LAST_UPDATE_LOGIN , L.CREATION_DATE , L.CREATED_BY , NVL(LL.START_DATE,H.START_DATE) , NVL(LL.END_DATE,H.END_DATE) , LL.QUANTITY , LL.PRICE_OVERRIDE , LL.UNIT_MEAS_LOOKUP_CODE , LL.UNIT_OF_MEASURE_CLASS , LL.LEAD_TIME , LL.LEAD_TIME_UNIT , NVL(LL.TERMS_ID,H.TERMS_ID) , NVL(LL.SHIP_TO_LOCATION_ID,H.SHIP_TO_LOCATION_ID) , H.BILL_TO_LOCATION_ID , NVL(LL.SHIP_VIA_LOOKUP_CODE,H.SHIP_VIA_LOOKUP_CODE) , NVL(LL.FOB_LOOKUP_CODE,H.FOB_LOOKUP_CODE) , NVL(LL.FREIGHT_TERMS_LOOKUP_CODE,H.FREIGHT_TERMS_LOOKUP_CODE) , L.ITEM_ID , L.ITEM_REVISION , L.CATEGORY_ID , L.ITEM_DESCRIPTION , L.VENDOR_PRODUCT_NUM , LL.TAXABLE_FLAG , L.NOTE_TO_VENDOR , L.MIN_ORDER_QUANTITY , L.MAX_ORDER_QUANTITY , L.QTY_RCV_TOLERANCE , L.OVER_TOLERANCE_ERROR_FLAG , LL.INSPECTION_REQUIRED_FLAG , LL.RECEIPT_REQUIRED_FLAG , L.UN_NUMBER_ID , L.HAZARD_CLASS_ID , H.AGENT_ID , H.NOTE_TO_VENDOR , NVL(QUOTE_TYPE_LOOKUP_CODE, 'BLANKET') , H.QUOTE_VENDOR_QUOTE_NUMBER , H.FROM_TYPE_LOOKUP_CODE , LL.FROM_HEADER_ID , LL.FROM_LINE_ID , LL.FROM_LINE_LOCATION_ID , H.COMMENTS , H.CURRENCY_CODE , H.RATE_TYPE , H.RATE_DATE , H.RATE , LL.ATTRIBUTE_CATEGORY , LL.ATTRIBUTE1 , LL.ATTRIBUTE2 , LL.ATTRIBUTE3 , LL.ATTRIBUTE4 , LL.ATTRIBUTE5 , LL.ATTRIBUTE6 , LL.ATTRIBUTE7 , LL.ATTRIBUTE8 , LL.ATTRIBUTE9 , LL.ATTRIBUTE10 , LL.ATTRIBUTE11 , LL.ATTRIBUTE12 , LL.ATTRIBUTE13 , LL.ATTRIBUTE14 , LL.ATTRIBUTE15 , H.TYPE_LOOKUP_CODE , H.APPROVAL_REQUIRED_FLAG , H.QUOTATION_CLASS_CODE , LL.TAX_CODE_ID ,H.ORG_ID FROM PO_LINE_LOCATIONS LL, PO_LINES_ALL L, PO_HEADERS_ALL H WHERE ((H.TYPE_LOOKUP_CODE = 'QUOTATION' AND H.STATUS_LOOKUP_CODE = 'A') OR (H.TYPE_LOOKUP_CODE = 'BLANKET' AND H.APPROVED_FLAG = 'Y' AND LL.SHIPMENT_TYPE = 'PRICE BREAK')) AND LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID

View Text - HTML Formatted

SELECT LL.LINE_LOCATION_ID
, LL.PO_LINE_ID
, LL.PO_HEADER_ID
, H.SEGMENT1
, L.LINE_NUM
, L.LINE_TYPE_ID
, H.VENDOR_ID
, H.VENDOR_SITE_ID
, H.VENDOR_CONTACT_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.CREATION_DATE
, L.CREATED_BY
, NVL(LL.START_DATE
, H.START_DATE)
, NVL(LL.END_DATE
, H.END_DATE)
, LL.QUANTITY
, LL.PRICE_OVERRIDE
, LL.UNIT_MEAS_LOOKUP_CODE
, LL.UNIT_OF_MEASURE_CLASS
, LL.LEAD_TIME
, LL.LEAD_TIME_UNIT
, NVL(LL.TERMS_ID
, H.TERMS_ID)
, NVL(LL.SHIP_TO_LOCATION_ID
, H.SHIP_TO_LOCATION_ID)
, H.BILL_TO_LOCATION_ID
, NVL(LL.SHIP_VIA_LOOKUP_CODE
, H.SHIP_VIA_LOOKUP_CODE)
, NVL(LL.FOB_LOOKUP_CODE
, H.FOB_LOOKUP_CODE)
, NVL(LL.FREIGHT_TERMS_LOOKUP_CODE
, H.FREIGHT_TERMS_LOOKUP_CODE)
, L.ITEM_ID
, L.ITEM_REVISION
, L.CATEGORY_ID
, L.ITEM_DESCRIPTION
, L.VENDOR_PRODUCT_NUM
, LL.TAXABLE_FLAG
, L.NOTE_TO_VENDOR
, L.MIN_ORDER_QUANTITY
, L.MAX_ORDER_QUANTITY
, L.QTY_RCV_TOLERANCE
, L.OVER_TOLERANCE_ERROR_FLAG
, LL.INSPECTION_REQUIRED_FLAG
, LL.RECEIPT_REQUIRED_FLAG
, L.UN_NUMBER_ID
, L.HAZARD_CLASS_ID
, H.AGENT_ID
, H.NOTE_TO_VENDOR
, NVL(QUOTE_TYPE_LOOKUP_CODE
, 'BLANKET')
, H.QUOTE_VENDOR_QUOTE_NUMBER
, H.FROM_TYPE_LOOKUP_CODE
, LL.FROM_HEADER_ID
, LL.FROM_LINE_ID
, LL.FROM_LINE_LOCATION_ID
, H.COMMENTS
, H.CURRENCY_CODE
, H.RATE_TYPE
, H.RATE_DATE
, H.RATE
, LL.ATTRIBUTE_CATEGORY
, LL.ATTRIBUTE1
, LL.ATTRIBUTE2
, LL.ATTRIBUTE3
, LL.ATTRIBUTE4
, LL.ATTRIBUTE5
, LL.ATTRIBUTE6
, LL.ATTRIBUTE7
, LL.ATTRIBUTE8
, LL.ATTRIBUTE9
, LL.ATTRIBUTE10
, LL.ATTRIBUTE11
, LL.ATTRIBUTE12
, LL.ATTRIBUTE13
, LL.ATTRIBUTE14
, LL.ATTRIBUTE15
, H.TYPE_LOOKUP_CODE
, H.APPROVAL_REQUIRED_FLAG
, H.QUOTATION_CLASS_CODE
, LL.TAX_CODE_ID
, H.ORG_ID
FROM PO_LINE_LOCATIONS LL
, PO_LINES_ALL L
, PO_HEADERS_ALL H
WHERE ((H.TYPE_LOOKUP_CODE = 'QUOTATION'
AND H.STATUS_LOOKUP_CODE = 'A') OR (H.TYPE_LOOKUP_CODE = 'BLANKET'
AND H.APPROVED_FLAG = 'Y'
AND LL.SHIPMENT_TYPE = 'PRICE BREAK'))
AND LL.PO_HEADER_ID = H.PO_HEADER_ID
AND LL.PO_LINE_ID = L.PO_LINE_ID