12: SUBSTRB(PARTY.PARTY_NAME
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
23: SUBSTRB(PARTY.PARTY_NAME
24: ,1
25: ,50) CUSTOMER_NAME
26: FROM
27: HZ_PARTIES PARTY,
28: PO_VENDORS PV
29: WHERE PV.PARTY_ID = PARTY.PARTY_ID
30: AND PV.VENDOR_ID = SUBSTR(P_CUSTOMER_ID,3);
31: --RTV changes