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: ******************************************************************************************/
1710:
1711: -- Get the customer name from ra_customers_view
1712: lstmt := 30;
1713: -- Bug fix 4570911 by Renga Kannan on 30-Aug-2005
1714: -- Replaced RA_CUSTOMER_VIEW reference with HZ_PARTIES sql
1715: -- RA_CUSTOMER_VIEW is obsoleted in R12 by fin team
1716:
1717: SELECT
1718: substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME
1716:
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