APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_K_ITEMS

Line 455: OKC_K_ITEMS CIM,

451: OKC_K_LINES_B TOP_CLE,
452: OKC_LINE_STYLES_b TOP_LSE,
453: OKC_K_LINES_B SUB_CLE,
454: OKC_LINE_STYLES_b SUB_LSE,
455: OKC_K_ITEMS CIM,
456: OKC_K_LINES_V FA,
457: OKC_LINE_STYLES_B AST_LSE,
458: OKL_CNSLD_AR_STRMS_B LSM
459: WHERE

Line 488: okc_k_items cim,

484: --cim.object1_id2 "#",
485: csi.install_location_id
486: , csi.location_id
487: FROM csi_item_instances csi,
488: okc_k_items cim,
489: okc_k_lines_b inst,
490: okc_k_lines_b ib,
491: okc_line_styles_b lse
492: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)

Line 945: OKC_K_ITEMS CIM,

941: OKC_K_LINES_B TOP_CLE,
942: OKC_LINE_STYLES_b TOP_LSE,
943: OKC_K_LINES_B SUB_CLE,
944: OKC_LINE_STYLES_b SUB_LSE,
945: OKC_K_ITEMS CIM,
946: OKC_K_LINES_V FA,
947: OKC_LINE_STYLES_B AST_LSE,
948: OKL_CNSLD_AR_STRMS_B LSM
949: WHERE

Line 978: okc_k_items cim,

974: --cim.object1_id2 "#",
975: csi.install_location_id
976: , csi.location_id
977: FROM csi_item_instances csi,
978: okc_k_items cim,
979: okc_k_lines_b inst,
980: okc_k_lines_b ib,
981: okc_line_styles_b lse
982: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)

Line 1019: okc_k_items c

1015: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1016: SELECT c.object1_id1
1017: FROM okc_k_lines_v a,
1018: okc_line_styles_v b,
1019: okc_k_items c
1020: WHERE a.lse_id = b.id
1021: AND b.lty_code = 'SOLD_SERVICE'
1022: AND a.id = p_cle_id
1023: AND c.cle_id = a.id;

Line 1033: okc_k_items c

1029: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1030: SELECT c.OBJECT1_ID1
1031: FROM okc_k_lines_b a,
1032: okc_line_styles_b b,
1033: okc_k_items c
1034: WHERE a.cle_id = p_fin_asset_line_id
1035: AND b.lty_code = 'ITEM'
1036: AND a.lse_id = b.id
1037: AND a.id = c.cle_id;