APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT SQL Statements

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

Line: 75

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

Line: 116

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

Line: 147

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

Line: 177

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

Line: 212

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

Line: 242

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

Line: 272

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

Line: 364

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

Line: 405

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

Line: 436

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

Line: 466

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

Line: 501

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

Line: 531

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

Line: 561

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