VIEW: APPS.XNB_SALESORDER_ACCOUNTS_V

Source

View Text - Preformatted

SELECT Customer_Accounts.order_number ORDER_NUMBER, Customer_Accounts.org_id ORG_ID, Accounts.account_number ACCOUNT_NUMBER from HZ_CUST_ACCOUNTS Accounts, (select Order_Header.sold_to_org_id, Order_Header.order_number, Order_Header.org_id from oe_order_headers_all Order_Header union select distinct Accounts.cust_account_id, Order_Header.order_number, Order_HEader.org_id from oe_order_headers_all Order_Header, oe_order_lines_all Order_Lines, hz_cust_site_uses_all Account_Site_Uses, hz_cust_acct_sites_all Account_Sites, hz_cust_accounts Accounts where Order_Header.header_id = Order_Lines.header_id and Order_Lines.invoice_to_org_id = Account_Site_Uses.site_use_id and Account_Site_Uses.cust_acct_site_id = Account_Sites.cust_acct_site_id and Accounts.cust_account_id = Account_Sites.cust_account_id) Customer_Accounts WHERE Accounts.cust_account_id = Customer_Accounts.sold_to_org_id

View Text - HTML Formatted

SELECT CUSTOMER_ACCOUNTS.ORDER_NUMBER ORDER_NUMBER
, CUSTOMER_ACCOUNTS.ORG_ID ORG_ID
, ACCOUNTS.ACCOUNT_NUMBER ACCOUNT_NUMBER
FROM HZ_CUST_ACCOUNTS ACCOUNTS
, (SELECT ORDER_HEADER.SOLD_TO_ORG_ID
, ORDER_HEADER.ORDER_NUMBER
, ORDER_HEADER.ORG_ID
FROM OE_ORDER_HEADERS_ALL ORDER_HEADER UNION SELECT DISTINCT ACCOUNTS.CUST_ACCOUNT_ID
, ORDER_HEADER.ORDER_NUMBER
, ORDER_HEADER.ORG_ID
FROM OE_ORDER_HEADERS_ALL ORDER_HEADER
, OE_ORDER_LINES_ALL ORDER_LINES
, HZ_CUST_SITE_USES_ALL ACCOUNT_SITE_USES
, HZ_CUST_ACCT_SITES_ALL ACCOUNT_SITES
, HZ_CUST_ACCOUNTS ACCOUNTS
WHERE ORDER_HEADER.HEADER_ID = ORDER_LINES.HEADER_ID
AND ORDER_LINES.INVOICE_TO_ORG_ID = ACCOUNT_SITE_USES.SITE_USE_ID
AND ACCOUNT_SITE_USES.CUST_ACCT_SITE_ID = ACCOUNT_SITES.CUST_ACCT_SITE_ID
AND ACCOUNTS.CUST_ACCOUNT_ID = ACCOUNT_SITES.CUST_ACCOUNT_ID) CUSTOMER_ACCOUNTS
WHERE ACCOUNTS.CUST_ACCOUNT_ID = CUSTOMER_ACCOUNTS.SOLD_TO_ORG_ID