Product: | PO - Purchasing |
---|---|
Description: | Sources for an item |
Implementation/DBA Data: | APPS.PO_ITEM_SOURCES |
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_ALL LL
, PO_LINES_ALL L
, PO_HEADERS 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