DBA Data[Home] [Help]

APPS.ECX_TP_API dependencies on PO_VENDOR_SITES_ALL

Line 2136: select p1.ADDRESS_LINE1||' '||p1.ADDRESS_LINE2||' '||p1.ADDRESS_LINE3||' '||p1.CITY||p1.ZIP from PO_VENDOR_SITES_ALL p1

2132: cursor supplier_party_name(v_party_id varchar) is
2133: select p.vendor_name from PO_VENDORS p where p.vendor_ID =v_party_id ;
2134:
2135: cursor supplier_site_name(v_party_id varchar,v_party_site_id varchar) is
2136: select p1.ADDRESS_LINE1||' '||p1.ADDRESS_LINE2||' '||p1.ADDRESS_LINE3||' '||p1.CITY||p1.ZIP from PO_VENDOR_SITES_ALL p1
2137: where p1.VENDOR_SITE_ID =v_party_site_id and p1.VENDOR_ID=v_party_id;
2138:
2139: cursor customer_party_name(v_party_id varchar) is
2140: select PARTY_NAME from hz_parties where party_id=v_party_id;

Line 2148: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;

2144: cursor org_table(v_party_id varchar) is
2145: select decode(party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from ecx_tp_headers where party_id =v_party_id ;
2146:
2147: cursor org_site_table(v_party_id varchar) is
2148: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;
2149:
2150:
2151: /* This cursor "orig_site_role" is defined to get the name of the orig_system from wf_local_roles
2152: ** This would be used when we are deleting a Trading Partner**