DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on HZ_CUST_ACCOUNTS

Line 1721: HZ_CUST_ACCOUNTS CUST_ACCT,

1717: SELECT
1718: substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME
1719: into lcustomer_name
1720: FROM HZ_PARTIES PARTY,
1721: HZ_CUST_ACCOUNTS CUST_ACCT,
1722: oe_order_headers_all oeh
1723: WHERE CUST_ACCT.CUST_ACCOUNT_ID = oeh.sold_to_org_id
1724: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1725: AND oeh.header_id = l_header_id;