APPS.OKS_COVERAGES_MIGRATION dependencies on OKC_K_LINES_B

Line 69: FROM OKC_K_LINES_B cle1,OKS_CON_LINES_INT_ALL ocl

65: cle1.CREATION_DATE CREATION_DATE,
66: cle1.LAST_UPDATED_BY LAST_UPDATED_BY,
67: cle1.LAST_UPDATE_DATE LAST_UPDATE_DATE,
68: cle1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
69: FROM OKC_K_LINES_B cle1,OKS_CON_LINES_INT_ALL ocl
70: WHERE cle1.Lse_Id = 1
71: AND cle1.UPG_ORIG_SYSTEM_REF_ID = ocl.contract_line_id
72: AND cle1.dnz_chr_Id <> -1
73: AND cle1.UPG_ORIG_SYSTEM_REF = g_line_ref

Line 86: Okc_k_Lines_b cle,

82:
83: CURSOR get_mtl_cov_id_cur is
84: select distinct coverage_schedule_id id
85: from mtl_system_items mtl,
86: Okc_k_Lines_b cle,
87: okc_k_Items cim
88: WHERE to_char(mtl.Inventory_Item_Id) = cim.object1_Id1
89: AND to_char(mtl.Organization_Id) = cim.object1_Id2
90: AND cle.Id = cim.Cle_Id

Line 896: okc_k_lines_b okl,

892: okl.dnz_chr_id,
893: okl.sts_code,
894: okl.currency_code
895: FROM oks_cov_txn_groups_int_all obp,
896: okc_k_lines_b okl,
897: oks_coverages_int_all cov,
898: oks_con_lines_int_all lines,
899: oks_con_headers_int_all head
900: WHERE okl.upg_Orig_System_Ref= g_covline_ref

Line 3391: okc_k_lines_b okl,

3387: okl.currency_code
3388: FROM
3389: oks_cov_bill_types_int_all obt ,
3390: oks_cov_txn_groups_int_all obp,
3391: okc_k_lines_b okl,
3392: oks_coverages_int_all cov,
3393: oks_con_lines_int_all lines,
3394: oks_con_headers_int_all head
3395:

Line 3838: okc_k_lines_b okl,

3834: okl.dnz_chr_id,
3835: okl.currency_code
3836: FROM oks_cov_bill_rates_int_all obr ,
3837: oks_cov_bill_types_int_all obt,
3838: okc_k_lines_b okl,
3839: oks_cov_txn_groups_int_all obp,
3840: oks_coverages_int_all cov,
3841: oks_con_lines_int_all lines,
3842: oks_con_headers_int_all head