DBA Data[Home] [Help]

APPS.OKS_CT_EVENTS_WFA dependencies on OKC_K_HEADERS_V

Line 132: okc_k_headers_v chr,

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
136: and cle.dnz_chr_id = chr.id

Line 149: from okc_k_headers_v okhv,

145:
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

Line 387: okc_k_headers_v okh

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
391: and assent.scs_code = okh.scs_code