APPS.ECX_TP_SYNCH SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

select party_id  from ecx_tp_headers;

Line: 30

select company_admin_email from ecx_tp_headers where party_id=p_party_id;

Line: 33

select party_type from ecx_tp_headers where party_id=p_party_id;

Line: 36

select party_site_id from ecx_tp_headers where party_id=p_party_id;

Line: 39

 select LOCATION_CODE  from hr_locations  where LOCATION_ID=v_party_id ;

Line: 42

 select ADDRESS_LINE_1||ADDRESS_LINE_2||ADDRESS_LINE_3 ||town_or_city||country||postal_code from hr_locations
 where location_id =v_party_id ;

Line: 46

select BANK_NAME from CE_BANK_BRANCHES_V where BRANCH_PARTY_ID=v_party_id;

Line: 49

select address_line1||' '||address_line2||' '||address_line3||' '||CITY||' '||ZIP from CE_BANK_BRANCHES_V where BRANCH_PARTY_ID=v_party_id;

Line: 52

select p.vendor_name from PO_VENDORS p  where p.vendor_ID =v_party_id;

Line: 55

select p1.ADDRESS_LINE1||' '||p1.ADDRESS_LINE2||' '||p1.ADDRESS_LINE3||' '||p1.CITY||p1.ZIP from  PO_VENDOR_SITES_ALL p1
  where  p1.VENDOR_SITE_ID =v_party_site_id and p1.VENDOR_ID=v_party_id;

Line: 60

select PARTY_NAME from hz_parties where party_id=v_party_id;

Line: 63

select ADDRESS1||' '||ADDRESS2||' ' || ADDRESS3 ||' '|| ADDRESS4||' ' ||CITY||' ' ||POSTAL_CODE||' ' ||
STATE ||' '||PROVINCE ||' '||COUNTY||' '||COUNTRY from hz_locations
where location_id =(select location_id from hz_party_sites where party_id=v_party_id and party_site_id=v_party_site_id);

Line: 68

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 ;

Line: 71

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 ;