View: OE_EM_PURGE_LOV_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_EM_PURGE_LOV_V

View Text

SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORG_ID
, SOLD_TO_ORG_ID
, 'OE_HEADERS_INTERFACE'
FROM OE_HEADERS_IFACE_ALL UNION SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORG_ID
, SOLD_TO_ORG_ID
, 'OE_LINES_INTERFACE'
FROM OE_LINES_IFACE_ALL UNION SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORG_ID
, SOLD_TO_ORG_ID
, 'OE_HEADER_ACKS'
FROM OE_HEADER_ACKS UNION SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORG_ID
, SOLD_TO_ORG_ID
, 'OE_EM_INFORMATION'
FROM OE_EM_INFORMATION

Columns