APPS.CTO_CHANGE_ORDER_PK dependencies on HZ_PARTIES

Line 170: | HZ_PARTIES made sql change

166: |
167: | Modified on 30-Aug-2005 Renga Kannan
168: | RA_CUSTOMERS_VIEW is obsoleted in R12
169: | and fin team is asking us to replace
170: | HZ_PARTIES made sql change
171: |
172: | 10-Oct-2005 Kiran Konada
173: | bugfix#4666504
174: ******************************************************************************************/

Line 1539: -- Replaced RA_CUSTOMER_VIEW reference with HZ_PARTIES sql

1535:
1536: -- Get the customer name from ra_customers_view
1537: lstmt := 30;
1538: -- Bug fix 4570911 by Renga Kannan on 30-Aug-2005
1539: -- Replaced RA_CUSTOMER_VIEW reference with HZ_PARTIES sql
1540: -- RA_CUSTOMER_VIEW is obsoleted in R12 by fin team
1541:
1542: SELECT
1543: substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME

Line 1545: FROM HZ_PARTIES PARTY,

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