APPS.WSH_BATCH_PROCESS dependencies on HZ_PARTIES

Line 2897: FROM hz_parties Party, hz_cust_accounts cust_acct

2893: --TCA View Changes Start
2894: --RTV changes
2895: CURSOR get_customer_name(c_customer_id varchar2) IS
2896: SELECT substrb ( party.party_name, 1, 50 ) customer_name
2897: FROM hz_parties Party, hz_cust_accounts cust_acct
2898: WHERE cust_acct.party_id = party.party_id AND
2899: cust_acct.cust_account_id = to_number(SubStr(c_customer_id,3))
2900: AND SubStr(c_customer_id,1,1) = 'C'
2901: UNION

Line 2903: FROM hz_parties Party, po_vendors pov

2899: cust_acct.cust_account_id = to_number(SubStr(c_customer_id,3))
2900: AND SubStr(c_customer_id,1,1) = 'C'
2901: UNION
2902: SELECT substrb ( party.party_name, 1, 50 ) customer_name
2903: FROM hz_parties Party, po_vendors pov
2904: WHERE pov.party_id = party.party_id
2905: AND pov.vendor_id = to_number(SubStr(c_customer_id,3))
2906: AND SubStr(c_customer_id,1,1) = 'V';
2907: --RTV changes

Line 3634: FROM hz_parties Party, hz_cust_accounts cust_acct

3630: --TCA View Changes Start
3631: --RTV changes
3632: CURSOR get_customer_name(c_customer_id varchar2) IS
3633: SELECT substrb ( party.party_name, 1, 50 ) customer_name
3634: FROM hz_parties Party, hz_cust_accounts cust_acct
3635: WHERE cust_acct.party_id = party.party_id AND
3636: cust_acct.cust_account_id = to_number(SubStr(c_customer_id,3))
3637: AND SubStr(c_customer_id,1,1) = 'C'
3638: UNION

Line 3640: FROM hz_parties Party, po_vendors pov

3636: cust_acct.cust_account_id = to_number(SubStr(c_customer_id,3))
3637: AND SubStr(c_customer_id,1,1) = 'C'
3638: UNION
3639: SELECT substrb ( party.party_name, 1, 50 ) customer_name
3640: FROM hz_parties Party, po_vendors pov
3641: WHERE pov.party_id = party.party_id
3642: AND pov.vendor_id = to_number(SubStr(c_customer_id,3))
3643: AND SubStr(c_customer_id,1,1) = 'V';
3644: --RTV changes --TCA View Changes end