Product: | ICX - Oracle iProcurement |
---|---|
Description: | Account Distribution Header View |
Implementation/DBA Data: | APPS.ICX_REQ_DIST_HEADER_V |
SELECT PORH.REQUISITION_HEADER_ID CART_ID
, PORH.SEGMENT1 REQUISITION_NUMBER
, PORH.PREPARER_ID SHOPPER_ID
, PORL.REQUISITION_LINE_ID CART_LINE_ID
, PORL.LINE_NUM CART_LINE_NUMBER
, PORL.REQUISITION_LINE_ID LINE_ID
, PORL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, PORL.ITEM_ID ITEM_ID
, PORL.ITEM_REVISION ITEM_REV
, PORL.UNIT_MEAS_LOOKUP_CODE UNIT_OF_MEASURE
, PORL.QUANTITY QUANTITY
, TO_CHAR( PORL.UNIT_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( GSOB.CURRENCY_CODE
, 30 )) UNIT_PRICE
, PORL.QUANTITY * PORL.UNIT_PRICE EXT_PRICE
, PORL.CATEGORY_ID CATEGORY_ID
, PORL.LINE_TYPE_ID LINE_TYPE_ID
, PORD.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PORL.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, PORL.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, PORL.SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID
, PORL.SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, PORL.SUGGESTED_VENDOR_LOCATION SUGGESTED_VENDOR_SITE
, PORL.SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT
, PORL.SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE
, PORL.SUGGESTED_VENDOR_PRODUCT_CODE SUGGESTED_VENDOR_ITEM_NUM
, PORL.ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, PORL.ATTRIBUTE1 LINE_ATTRIBUTE1
, PORL.ATTRIBUTE2 LINE_ATTRIBUTE2
, PORL.ATTRIBUTE3 LINE_ATTRIBUTE3
, PORL.ATTRIBUTE4 LINE_ATTRIBUTE4
, PORL.ATTRIBUTE5 LINE_ATTRIBUTE5
, PORL.ATTRIBUTE6 LINE_ATTRIBUTE6
, PORL.ATTRIBUTE7 LINE_ATTRIBUTE7
, PORL.ATTRIBUTE8 LINE_ATTRIBUTE8
, PORL.ATTRIBUTE9 LINE_ATTRIBUTE9
, PORL.ATTRIBUTE10 LINE_ATTRIBUTE10
, PORL.ATTRIBUTE11 LINE_ATTRIBUTE11
, PORL.ATTRIBUTE12 LINE_ATTRIBUTE12
, PORL.ATTRIBUTE13 LINE_ATTRIBUTE13
, PORL.ATTRIBUTE14 LINE_ATTRIBUTE14
, PORL.ATTRIBUTE15 LINE_ATTRIBUTE15
, PORL.NEED_BY_DATE NEED_BY_DATE
, PORD.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PORD.PROJECT_ID PROJECT_ID
, PORD.TASK_ID TASK_ID
, PORD.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PORD.DISTRIBUTION_ID
, ICX_UTIL.CATEGORY_FLEX_SEG(PORL.CATEGORY_ID) CATEGORY_NAME
, PORH.ORG_ID
FROM PO_REQUISITION_HEADERS PORH
, PO_REQUISITION_LINES PORL
, PO_REQ_DISTRIBUTIONS PORD
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_SETS_OF_BOOKS GSOB
WHERE PORH.REQUISITION_HEADER_ID= PORL.REQUISITION_HEADER_ID (+)
AND PORL.REQUISITION_LINE_ID = PORD.REQUISITION_LINE_ID (+)
AND NVL(PORL.DESTINATION_ORGANIZATION_ID
, -9999) = NVL(OOD.ORGANIZATION_ID
, -9999)
AND GSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID