eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_LINE_STYLES_B

Line 452: OKC_LINE_STYLES_b TOP_LSE,

448: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
449: SELECT FA.ID
450: FROM OKC_K_HEADERS_B CHR,
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,

Line 454: OKC_LINE_STYLES_b SUB_LSE,

450: FROM OKC_K_HEADERS_B CHR,
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

Line 457: OKC_LINE_STYLES_B AST_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
460: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
461: TOP_CLE.LSE_ID = TOP_LSE.ID AND

Line 491: okc_line_styles_b lse

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)
493: AND cim.cle_id = ib.id
494: AND ib.cle_id = inst.id
495: AND inst.lse_id = lse.id

Line 546: -- okc_line_styles_b lse

542:
543: CURSOR get_top_line ( p_cle_id NUMBER ) IS
544: select cle.id--, lse.lty_code
545: from okc_k_lines_b cle--,
546: -- okc_line_styles_b lse
547: -- where lse.id = cle.lse_id
548: -- and cle.cle_id is null
549: where cle.cle_id is null -- it's top line
550: start with cle.id = p_cle_id

Line 942: OKC_LINE_STYLES_b TOP_LSE,

938: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
939: SELECT FA.ID
940: FROM OKC_K_HEADERS_B CHR,
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,

Line 944: OKC_LINE_STYLES_b SUB_LSE,

940: FROM OKC_K_HEADERS_B CHR,
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

Line 947: OKC_LINE_STYLES_B AST_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
950: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
951: TOP_CLE.LSE_ID = TOP_LSE.ID AND

Line 981: okc_line_styles_b lse

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)
983: AND cim.cle_id = ib.id
984: AND ib.cle_id = inst.id
985: AND inst.lse_id = lse.id

Line 1032: okc_line_styles_b b,

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

Line 1076: -- okc_line_styles_b lse

1072:
1073: CURSOR get_top_line ( p_cle_id NUMBER ) IS
1074: select cle.id--, lse.lty_code
1075: from okc_k_lines_b cle--,
1076: -- okc_line_styles_b lse
1077: -- where lse.id = cle.lse_id
1078: -- and cle.cle_id is null
1079: where cle.cle_id is null -- it's top line
1080: start with cle.id = p_cle_id