[Home] [Help]
127:
128:
129: CURSOR contract_cur IS
130: select cpl.object1_id1 customer_id,opv.name customer_name,opv.party_number party_number
131: from okc_k_lines_v cle,
132: okc_k_headers_v chr,
133: okc_k_party_roles_b cpl,
134: okx_parties_v opv
135: where cle.id = l_k_line_id
146: CURSOR c_req_summary IS
147: select 'CONTRACT - '||okhv.contract_number||'; MODIFIER - '||okhv.contract_number_modifier||
148: '; SERVICE - '||msi.segment1||'; LINE NO. - '||oklv.line_number SR_SUMMARY
149: from okc_k_headers_v okhv,
150: okc_k_lines_v oklv,
151: okc_k_items cim,
152: mtl_system_items msi
153: where okhv.id = oklv.chr_id
154: and oklv.id = l_k_line_id
343: csc_hz_contact_points_v chcpv
344: where obj_party_type = 'ORGANIZATION'
345: and object_id = (select object1_id1 from okc_k_party_roles_v
346: where jtot_object1_code = 'OKX_PARTY'
347: and chr_id = (select chr_id from okc_k_lines_v where id = l_k_line_id)
348: and rownum = 1) --l_party_id
349: and chpv.party_id = chcpv.party_id --and chpv.subject_id = chcpv.party_id
350: and chcpv.PRIMARY_FLAG = 'Y'
351: and chcpv.party_TYPE = 'PARTY_RELATIONSHIP' --'PERSON'
364: hz_relationships r
365: where chpv.obj_party_type = 'ORGANIZATION'
366: and chpv.object_id = (select object1_id1 from okc_k_party_roles_v
367: where jtot_object1_code = 'OKX_PARTY'
368: and chr_id = (select chr_id from okc_k_lines_v where
369: id = l_k_line_id)
370: and rownum = 1)
371: and chpv.party_id = chcpv.party_id
372: and chcpv.PRIMARY_FLAG = 'Y'
382:
383: CURSOR status IS
384: select assent.opn_code opn_code
385: from okc_assents_v assent,
386: okc_k_lines_v cle ,
387: okc_k_headers_v okh
388: where cle.id = l_k_line_id
389: and okh.id = cle.dnz_chr_id
390: and assent.sts_code = cle.sts_code