VIEW: APPS.ICX_SHOPPING_CARTS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)