VIEW: APPS.ICX_CART_LINE_ACCOUNT_HEADER_V

Source

View Text - Preformatted

SELECT ISC.CART_ID CART_ID , ISC.REQ_NUMBER_SEGMENT1 REQUISITION_NUMBER , 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 , TO_CHAR( ISCL.UNIT_PRICE, FND_CURRENCY.SAFE_GET_FORMAT_MASK( GSOB.CURRENCY_CODE, 30 )) 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

View Text - HTML Formatted

SELECT ISC.CART_ID CART_ID
, ISC.REQ_NUMBER_SEGMENT1 REQUISITION_NUMBER
, 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
, TO_CHAR( ISCL.UNIT_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( GSOB.CURRENCY_CODE
, 30 )) 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