eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_SHOPPING_CARTS_V

Product:	ICX - Oracle iProcurement
Description:	Web Requisitions Header View
Implementation/DBA Data:	APPS.ICX_SHOPPING_CARTS_V

View Text

SELECT ISC.CART_ID
, ISC.SHOPPER_ID
, ISC.SAVED_FLAG
, ISC.EMERGENCY_FLAG
, ISC.CREATION_DATE
, ISC.APPROVER_ID
, ISC.APPROVER_NAME
, ISC.NOTE_TO_APPROVER
, ISC.REQ_NUMBER_SEGMENT1
, ISC.RESERVED_PO_NUM
, ISC.HEADER_DESCRIPTION
, ISC.HEADER_ATTRIBUTE_CATEGORY
, ISC.HEADER_ATTRIBUTE1
, ISC.HEADER_ATTRIBUTE2
, ISC.HEADER_ATTRIBUTE3
, ISC.HEADER_ATTRIBUTE4
, ISC.HEADER_ATTRIBUTE5
, ISC.HEADER_ATTRIBUTE6
, ISC.HEADER_ATTRIBUTE7
, ISC.HEADER_ATTRIBUTE8
, ISC.HEADER_ATTRIBUTE9
, ISC.HEADER_ATTRIBUTE10
, ISC.HEADER_ATTRIBUTE11
, ISC.HEADER_ATTRIBUTE12
, ISC.HEADER_ATTRIBUTE13
, ISC.HEADER_ATTRIBUTE14
, ISC.HEADER_ATTRIBUTE15
, ISC.NOTE_TO_BUYER
, ISC.DESTINATION_TYPE_CODE
, ISC.DESTINATION_ORGANIZATION_ID
, ISC.DELIVER_TO_LOCATION_ID
, ISC.DELIVER_TO_REQUESTOR_ID
, ISC.NEED_BY_DATE
, ICD.DISTRIBUTION_ID
, ICD.CHARGE_ACCOUNT_SEGMENT1
, ICD.CHARGE_ACCOUNT_SEGMENT2
, ICD.CHARGE_ACCOUNT_SEGMENT3
, ICD.CHARGE_ACCOUNT_SEGMENT4
, ICD.CHARGE_ACCOUNT_SEGMENT5
, ICD.CHARGE_ACCOUNT_SEGMENT6
, ICD.CHARGE_ACCOUNT_SEGMENT7
, ICD.CHARGE_ACCOUNT_SEGMENT8
, ICD.CHARGE_ACCOUNT_SEGMENT9
, ICD.CHARGE_ACCOUNT_SEGMENT10
, ICD.CHARGE_ACCOUNT_SEGMENT11
, ICD.CHARGE_ACCOUNT_SEGMENT12
, ICD.CHARGE_ACCOUNT_SEGMENT13
, ICD.CHARGE_ACCOUNT_SEGMENT14
, ICD.CHARGE_ACCOUNT_SEGMENT15
, ICD.CHARGE_ACCOUNT_SEGMENT16
, ICD.CHARGE_ACCOUNT_SEGMENT17
, ICD.CHARGE_ACCOUNT_SEGMENT18
, ICD.CHARGE_ACCOUNT_SEGMENT19
, ICD.CHARGE_ACCOUNT_SEGMENT20
, ICD.CHARGE_ACCOUNT_SEGMENT21
, ICD.CHARGE_ACCOUNT_SEGMENT22
, ICD.CHARGE_ACCOUNT_SEGMENT23
, ICD.CHARGE_ACCOUNT_SEGMENT24
, ICD.CHARGE_ACCOUNT_SEGMENT25
, ICD.CHARGE_ACCOUNT_SEGMENT26
, ICD.CHARGE_ACCOUNT_SEGMENT27
, ICD.CHARGE_ACCOUNT_SEGMENT28
, ICD.CHARGE_ACCOUNT_SEGMENT29
, ICD.CHARGE_ACCOUNT_SEGMENT30
, ISC.ORG_ID
, ISC.DELIVER_TO_LOCATION
, ISC.DELIVER_TO_REQUESTOR
FROM ICX_SHOPPING_CARTS ISC
, ICX_CART_DISTRIBUTIONS ICD
WHERE ISC.CART_ID = ICD.CART_ID (+)

Columns

Name
CART_ID
SHOPPER_ID
SAVED_FLAG
EMERGENCY_FLAG
CREATION_DATE
APPROVER_ID
APPROVER_NAME
NOTE_TO_APPROVER
REQ_NUMBER_SEGMENT1
RESERVED_PO_NUM
HEADER_DESCRIPTION
HEADER_ATTRIBUTE_CATEGORY
HEADER_ATTRIBUTE1
HEADER_ATTRIBUTE2
HEADER_ATTRIBUTE3
HEADER_ATTRIBUTE4
HEADER_ATTRIBUTE5
HEADER_ATTRIBUTE6
HEADER_ATTRIBUTE7
HEADER_ATTRIBUTE8
HEADER_ATTRIBUTE9
HEADER_ATTRIBUTE10
HEADER_ATTRIBUTE11
HEADER_ATTRIBUTE12
HEADER_ATTRIBUTE13
HEADER_ATTRIBUTE14
HEADER_ATTRIBUTE15
NOTE_TO_BUYER
DESTINATION_TYPE_CODE
DESTINATION_ORGANIZATION_ID
DELIVER_TO_LOCATION_ID
DELIVER_TO_REQUESTOR_ID
NEED_BY_DATE
DISTRIBUTION_ID
CHARGE_ACCOUNT_SEGMENT1
CHARGE_ACCOUNT_SEGMENT2
CHARGE_ACCOUNT_SEGMENT3
CHARGE_ACCOUNT_SEGMENT4
CHARGE_ACCOUNT_SEGMENT5
CHARGE_ACCOUNT_SEGMENT6
CHARGE_ACCOUNT_SEGMENT7
CHARGE_ACCOUNT_SEGMENT8
CHARGE_ACCOUNT_SEGMENT9
CHARGE_ACCOUNT_SEGMENT10
CHARGE_ACCOUNT_SEGMENT11
CHARGE_ACCOUNT_SEGMENT12
CHARGE_ACCOUNT_SEGMENT13
CHARGE_ACCOUNT_SEGMENT14
CHARGE_ACCOUNT_SEGMENT15
CHARGE_ACCOUNT_SEGMENT16
CHARGE_ACCOUNT_SEGMENT17
CHARGE_ACCOUNT_SEGMENT18
CHARGE_ACCOUNT_SEGMENT19
CHARGE_ACCOUNT_SEGMENT20
CHARGE_ACCOUNT_SEGMENT21
CHARGE_ACCOUNT_SEGMENT22
CHARGE_ACCOUNT_SEGMENT23
CHARGE_ACCOUNT_SEGMENT24
CHARGE_ACCOUNT_SEGMENT25
CHARGE_ACCOUNT_SEGMENT26
CHARGE_ACCOUNT_SEGMENT27
CHARGE_ACCOUNT_SEGMENT28
CHARGE_ACCOUNT_SEGMENT29
CHARGE_ACCOUNT_SEGMENT30
ORG_ID
DELIVER_TO_LOCATION
DELIVER_TO_REQUESTOR