VIEW: APPS.AS_OPPORTUNITY_ORDERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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