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
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
|
|
|