VIEW: APPS.ICX_REQ_DIST_HEADER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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