DBA Data[Home] [Help]

APPS.WSH_BATCH_PROCESS dependencies on PO_VENDORS

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