The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT '||
' NVL(o.name,'' '') as org_name '||
' ,NVL(c.contract_number,'' '') as contract_number '||
' ,NVL(c.contract_name,'' '') as contract_name '||
' ,NVL(c.contract_desc,'' '') as description '||
' ,NVL(c.keywords,'' '') as keywords '||
' ,NVL(c.version_comments,'' '') as version_comments '||
'FROM '||
'okc_rep_contracts_all c, '||
'hr_all_organization_units_vl o '||
'WHERE c.org_id = o.organization_id '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(o.name,'' '') as party_name '||
'FROM '||
'okc_rep_contracts_all c, '||
'okc_rep_contract_parties p, '||
'hr_all_organization_units_vl o '||
'WHERE c.contract_id = p.contract_id '||
'AND p.party_id = o.organization_id '||
'AND p.party_role_code = '''|| G_PARTY_TYPE_INTERNAL || ''' ' ||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(v.vendor_name,'' '') as party_name '||
'FROM '||
'okc_rep_contracts_all c, '||
'okc_rep_contract_parties p, '||
'po_vendors v '||
'WHERE c.contract_id = p.contract_id '||
'AND p.party_id = v.vendor_id '||
'AND p.party_role_code = '''|| G_PARTY_TYPE_SUPPLIER || ''' ' ||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(hz.party_name,'' '') as party_name '||
'FROM '||
'okc_rep_contracts_all c, '||
'okc_rep_contract_parties p, '||
'hz_parties hz '||
'WHERE c.contract_id = p.contract_id '||
'AND p.party_id = hz.party_id '||
'AND p.party_role_code IN (''' || G_PARTY_TYPE_CUSTOMER ||''', '''|| G_PARTY_TYPE_PARTNER || ''') '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(per.full_name,'' '') as contact_name '||
'FROM '||
'okc_rep_contracts_all c, '||
'okc_rep_party_contacts ct, '||
'per_all_people_f per '||
'WHERE c.contract_id = ct.contract_id '||
'AND ct.party_role_code = ''' || G_PARTY_TYPE_INTERNAL || ''' ' ||
'AND ct.contact_id = per.person_id '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL2(v.last_name, v.last_name||'' ''||v.first_name, '' '') as contact_name '||
'FROM '||
'okc_rep_contracts_all c, '||
'okc_rep_party_contacts ct, '||
'po_vendor_contacts v '||
'WHERE c.contract_id = ct.contract_id '||
'AND ct.contact_id = v.vendor_contact_id '||
'AND ct.PARTY_ROLE_CODE = '''|| G_PARTY_TYPE_SUPPLIER || ''' ' ||
'AND c.rowid = :1 ';
'SELECT '||
' hz.party_name AS contact_name '||
'FROM '||
'okc_rep_contracts_all c, '||
'okc_rep_party_contacts ct, '||
'hz_parties hz '||
'WHERE c.contract_id = ct.contract_id '||
'AND ct.party_role_code IN ( '''||G_PARTY_TYPE_CUSTOMER ||''', '''|| G_PARTY_TYPE_PARTNER || ''') '||
'AND ct.contact_id = hz.party_id '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(o.name,'' '') as org_name '||
' ,NVL(c.contract_number,'' '') as contract_number '||
' ,NVL(c.contract_name,'' '') as contract_name '||
' ,NVL(c.contract_desc,'' '') as description '||
' ,NVL(c.keywords,'' '') as keywords '||
' ,NVL(c.version_comments,'' '') as version_comments '||
'FROM '||
'okc_rep_contract_vers c, '||
'hr_all_organization_units_vl o '||
'WHERE c.org_id = o.organization_id '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(o.name,'' '') as party_name '||
'FROM '||
'okc_rep_contract_vers c, '||
'okc_rep_contract_parties p, '||
'hr_all_organization_units_vl o '||
'WHERE c.contract_id = p.contract_id '||
'AND p.party_id = o.organization_id '||
'AND p.party_role_code = '''|| G_PARTY_TYPE_INTERNAL || ''' ' ||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(v.vendor_name,'' '') as party_name '||
'FROM '||
'okc_rep_contract_vers c, '||
'okc_rep_contract_parties p, '||
'po_vendors v '||
'WHERE c.contract_id = p.contract_id '||
'AND p.party_id = v.vendor_id '||
'AND p.party_role_code = '''|| G_PARTY_TYPE_SUPPLIER || ''' ' ||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(hz.party_name,'' '') as party_name '||
'FROM '||
'okc_rep_contract_vers c, '||
'okc_rep_contract_parties p, '||
'hz_parties hz '||
'WHERE c.contract_id = p.contract_id '||
'AND p.party_id = hz.party_id '||
'AND p.party_role_code IN (''' || G_PARTY_TYPE_CUSTOMER ||''', '''|| G_PARTY_TYPE_PARTNER || ''') '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL(per.full_name,'' '') as contact_name '||
'FROM '||
'okc_rep_contract_vers c, '||
'okc_rep_party_contacts ct, '||
'per_all_people_f per '||
'WHERE c.contract_id = ct.contract_id '||
'AND ct.party_role_code = ''' || G_PARTY_TYPE_INTERNAL || ''' ' ||
'AND ct.contact_id = per.person_id '||
'AND c.rowid = :1 ';
'SELECT '||
' NVL2(v.last_name, v.last_name||'' ''||v.first_name, '' '') as contact_name '||
'FROM '||
'okc_rep_contract_vers c, '||
'okc_rep_party_contacts ct, '||
'po_vendor_contacts v '||
'WHERE c.contract_id = ct.contract_id '||
'AND ct.contact_id = v.vendor_contact_id '||
'AND ct.PARTY_ROLE_CODE = '''|| G_PARTY_TYPE_SUPPLIER || ''' ' ||
'AND c.rowid = :1 ';
'SELECT '||
' hz.party_name AS contact_name '||
'FROM '||
'okc_rep_contract_vers c, '||
'okc_rep_party_contacts ct, '||
'hz_parties hz '||
'WHERE c.contract_id = ct.contract_id '||
'AND ct.party_role_code IN ( '''||G_PARTY_TYPE_CUSTOMER ||''', '''|| G_PARTY_TYPE_PARTNER || ''') '||
'AND ct.contact_id = hz.party_id '||
'AND c.rowid = :1 ';