Product: | AS - Sales Foundation |
---|---|
Description: | Sales opportunity orders view |
Implementation/DBA Data: | APPS.AS_OPPORTUNITY_ORDERS_V |
SELECT ASLORD.ROWID ROW_ID
, ASLORD.LEAD_ORDER_ID
, ASLORD.LAST_UPDATE_DATE
, ASLORD.LAST_UPDATED_BY
, ASLORD.CREATION_DATE
, ASLORD.CREATED_BY
, ASLORD.LAST_UPDATE_LOGIN
, ASLORD.REQUEST_ID
, ASLORD.PROGRAM_APPLICATION_ID
, ASLORD.PROGRAM_ID
, ASLORD.PROGRAM_UPDATE_DATE
, ASLORD.LEAD_ID
, ASLORD.ORDER_HEADER_ID
, ASOHEADERSV.ORDER_NUMBER
, ASOHEADERSV.ORDERED_DATE DATE_ORDERED
, ASOHEADERSV.ORDER_TYPE_ID
, ASOHEADERSV.TRANSACTIONAL_CURR_CODE CURRENCY_CODE
, ASLORD.ATTRIBUTE_CATEGORY
, ASLORD.ATTRIBUTE1
, ASLORD.ATTRIBUTE2
, ASLORD.ATTRIBUTE3
, ASLORD.ATTRIBUTE4
, ASLORD.ATTRIBUTE5
, ASLORD.ATTRIBUTE6
, ASLORD.ATTRIBUTE7
, ASLORD.ATTRIBUTE8
, ASLORD.ATTRIBUTE9
, ASLORD.ATTRIBUTE10
, ASLORD.ATTRIBUTE11
, ASLORD.ATTRIBUTE12
, ASLORD.ATTRIBUTE13
, ASLORD.ATTRIBUTE14
, ASLORD.ATTRIBUTE15
FROM AS_LEAD_ORDERS ASLORD
, OE_ORDER_HEADERS_ALL ASOHEADERSV
WHERE ASLORD.ORDER_HEADER_ID = ASOHEADERSV.HEADER_ID