DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on HZ_CUST_ACCOUNTS

Line 1546: HZ_CUST_ACCOUNTS CUST_ACCT,

1542: SELECT
1543: substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME
1544: into lcustomer_name
1545: FROM HZ_PARTIES PARTY,
1546: HZ_CUST_ACCOUNTS CUST_ACCT,
1547: oe_order_headers_all oeh
1548: WHERE CUST_ACCT.CUST_ACCOUNT_ID = oeh.sold_to_org_id
1549: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1550: AND oeh.header_id = l_header_id;