Product: | ICX - Oracle iProcurement |
---|---|
Description: | Web Requisitions Lines View |
Implementation/DBA Data: | APPS.ICX_SHOPPING_CART_LINES_V |
SELECT ISC.CART_ID CART_ID
, ISC.SHOPPER_ID SHOPPER_ID
, ISCL.CART_LINE_ID CART_LINE_ID
, ISCL.CART_LINE_NUMBER CART_LINE_NUMBER
, ISCL.LINE_ID LINE_ID
, ISCL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, ISCL.ITEM_ID ITEM_ID
, ISCL.ITEM_REVISION ITEM_REV
, ISCL.UNIT_OF_MEASURE UNIT_OF_MEASURE
, ISCL.QUANTITY QUANTITY
, ISCL.UNIT_PRICE UNIT_PRICE
, ISCL.QUANTITY * ISCL.UNIT_PRICE EXT_PRICE
, ISCL.CATEGORY_ID CATEGORY_ID
, ISCL.LINE_TYPE_ID LINE_TYPE_ID
, ISCL.EXPENDITURE_TYPE EXPENDITURE_TYPE
, ISCL.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, ISCL.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, ISCL.SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID
, ISCL.SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, ISCL.SUGGESTED_VENDOR_SITE SUGGESTED_VENDOR_SITE
, ISCL.SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT
, ISCL.SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE
, ISCL.SUGGESTED_VENDOR_ITEM_NUM SUGGESTED_VENDOR_ITEM_NUM
, ISCL.LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, ISCL.LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, ISCL.LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, ISCL.LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, ISCL.LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, ISCL.LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, ISCL.LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, ISCL.LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, ISCL.LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, ISCL.LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, ISCL.LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, ISCL.LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, ISCL.LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, ISCL.LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, ISCL.LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, ISCL.LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, ISCL.NEED_BY_DATE NEED_BY_DATE
, ISCL.AUTOSOURCE_DOC_HEADER_ID AUTOSOURCE_DOC_HEADER_ID
, ISCL.AUTOSOURCE_DOC_LINE_NUM AUTOSOURCE_DOC_LINE_NUM
, ISCL.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, ISCL.PROJECT_ID PROJECT_ID
, ISCL.TASK_ID TASK_ID
, ISCL.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, ICLD.DISTRIBUTION_ID
, ICLD.CHARGE_ACCOUNT_SEGMENT1
, ICLD.CHARGE_ACCOUNT_SEGMENT2
, ICLD.CHARGE_ACCOUNT_SEGMENT3
, ICLD.CHARGE_ACCOUNT_SEGMENT4
, ICLD.CHARGE_ACCOUNT_SEGMENT5
, ICLD.CHARGE_ACCOUNT_SEGMENT6
, ICLD.CHARGE_ACCOUNT_SEGMENT7
, ICLD.CHARGE_ACCOUNT_SEGMENT8
, ICLD.CHARGE_ACCOUNT_SEGMENT9
, ICLD.CHARGE_ACCOUNT_SEGMENT10
, ICLD.CHARGE_ACCOUNT_SEGMENT11
, ICLD.CHARGE_ACCOUNT_SEGMENT12
, ICLD.CHARGE_ACCOUNT_SEGMENT13
, ICLD.CHARGE_ACCOUNT_SEGMENT14
, ICLD.CHARGE_ACCOUNT_SEGMENT15
, ICLD.CHARGE_ACCOUNT_SEGMENT16
, ICLD.CHARGE_ACCOUNT_SEGMENT17
, ICLD.CHARGE_ACCOUNT_SEGMENT18
, ICLD.CHARGE_ACCOUNT_SEGMENT19
, ICLD.CHARGE_ACCOUNT_SEGMENT20
, ICLD.CHARGE_ACCOUNT_SEGMENT21
, ICLD.CHARGE_ACCOUNT_SEGMENT22
, ICLD.CHARGE_ACCOUNT_SEGMENT23
, ICLD.CHARGE_ACCOUNT_SEGMENT24
, ICLD.CHARGE_ACCOUNT_SEGMENT25
, ICLD.CHARGE_ACCOUNT_SEGMENT26
, ICLD.CHARGE_ACCOUNT_SEGMENT27
, ICLD.CHARGE_ACCOUNT_SEGMENT28
, ICLD.CHARGE_ACCOUNT_SEGMENT29
, ICLD.CHARGE_ACCOUNT_SEGMENT30
, ICX_UTIL.CATEGORY_FLEX_SEG(ISCL.CATEGORY_ID) CATEGORY_NAME
, ISCL.ORG_ID
, ISCL.EXPRESS_NAME
, ISCL.ITEM_NUMBER
, ISCL.CUSTOM_DEFAULTED
, ISCL.DELIVER_TO_LOCATION
FROM ICX_SHOPPING_CARTS ISC
, ICX_SHOPPING_CART_LINES ISCL
, ICX_CART_LINE_DISTRIBUTIONS ICLD
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_SETS_OF_BOOKS GSOB
WHERE ISC.CART_ID = ISCL.CART_ID
AND ISCL.CART_LINE_ID = ICLD.CART_LINE_ID (+)
AND NVL(ISCL.DESTINATION_ORGANIZATION_ID
, -9999) = NVL(OOD.ORGANIZATION_ID
, -9999)
AND GSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND ICLD.DISTRIBUTION_NUM = 1
AND ISCL.CART_ID = ICLD.CART_ID (+)