[Home] [Help]
13: ,1
14: ,50) CUSTOMER_NAME
15: FROM
16: HZ_PARTIES PARTY,
17: HZ_CUST_ACCOUNTS CUST_ACCT
18: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
19: AND CUST_ACCT.CUST_ACCOUNT_ID = SUBSTR(P_CUSTOMER_ID,3); --RTV changes
20: --RTV changes
21: CURSOR GET_SUPPLIER IS