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 694: OKC_LINE_STYLES_b TOP_LSE,

690: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
691: SELECT FA.ID
692: FROM OKC_K_HEADERS_B CHR,
693: OKC_K_LINES_B TOP_CLE,
694: OKC_LINE_STYLES_b TOP_LSE,
695: OKC_K_LINES_B SUB_CLE,
696: OKC_LINE_STYLES_b SUB_LSE,
697: OKC_K_ITEMS CIM,
698: OKC_K_LINES_V FA,

Line 696: OKC_LINE_STYLES_b SUB_LSE,

692: FROM OKC_K_HEADERS_B CHR,
693: OKC_K_LINES_B TOP_CLE,
694: OKC_LINE_STYLES_b TOP_LSE,
695: OKC_K_LINES_B SUB_CLE,
696: OKC_LINE_STYLES_b SUB_LSE,
697: OKC_K_ITEMS CIM,
698: OKC_K_LINES_V FA,
699: OKC_LINE_STYLES_B AST_LSE,
700: OKL_CNSLD_AR_STRMS_B LSM

Line 699: OKC_LINE_STYLES_B AST_LSE,

695: OKC_K_LINES_B SUB_CLE,
696: OKC_LINE_STYLES_b SUB_LSE,
697: OKC_K_ITEMS CIM,
698: OKC_K_LINES_V FA,
699: OKC_LINE_STYLES_B AST_LSE,
700: OKL_CNSLD_AR_STRMS_B LSM
701: WHERE
702: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
703: TOP_CLE.LSE_ID = TOP_LSE.ID AND

Line 733: okc_line_styles_b lse

729: FROM csi_item_instances csi,
730: okc_k_items cim,
731: okc_k_lines_b inst,
732: okc_k_lines_b ib,
733: okc_line_styles_b lse
734: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
735: AND cim.cle_id = ib.id
736: AND ib.cle_id = inst.id
737: AND inst.lse_id = lse.id

Line 788: -- okc_line_styles_b lse

784:
785: CURSOR get_top_line ( p_cle_id NUMBER ) IS
786: select cle.id--, lse.lty_code
787: from okc_k_lines_b cle--,
788: -- okc_line_styles_b lse
789: -- where lse.id = cle.lse_id
790: -- and cle.cle_id is null
791: where cle.cle_id is null -- it's top line
792: start with cle.id = p_cle_id

Line 1150: OKC_LINE_STYLES_b TOP_LSE,

1146: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
1147: SELECT FA.ID
1148: FROM OKC_K_HEADERS_B CHR,
1149: OKC_K_LINES_B TOP_CLE,
1150: OKC_LINE_STYLES_b TOP_LSE,
1151: OKC_K_LINES_B SUB_CLE,
1152: OKC_LINE_STYLES_b SUB_LSE,
1153: OKC_K_ITEMS CIM,
1154: OKC_K_LINES_V FA,

Line 1152: OKC_LINE_STYLES_b SUB_LSE,

1148: FROM OKC_K_HEADERS_B CHR,
1149: OKC_K_LINES_B TOP_CLE,
1150: OKC_LINE_STYLES_b TOP_LSE,
1151: OKC_K_LINES_B SUB_CLE,
1152: OKC_LINE_STYLES_b SUB_LSE,
1153: OKC_K_ITEMS CIM,
1154: OKC_K_LINES_V FA,
1155: OKC_LINE_STYLES_B AST_LSE,
1156: OKL_CNSLD_AR_STRMS_B LSM

Line 1155: OKC_LINE_STYLES_B AST_LSE,

1151: OKC_K_LINES_B SUB_CLE,
1152: OKC_LINE_STYLES_b SUB_LSE,
1153: OKC_K_ITEMS CIM,
1154: OKC_K_LINES_V FA,
1155: OKC_LINE_STYLES_B AST_LSE,
1156: OKL_CNSLD_AR_STRMS_B LSM
1157: WHERE
1158: CHR.ID = TOP_CLE.DNZ_CHR_ID AND
1159: TOP_CLE.LSE_ID = TOP_LSE.ID AND

Line 1189: okc_line_styles_b lse

1185: FROM csi_item_instances csi,
1186: okc_k_items cim,
1187: okc_k_lines_b inst,
1188: okc_k_lines_b ib,
1189: okc_line_styles_b lse
1190: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
1191: AND cim.cle_id = ib.id
1192: AND ib.cle_id = inst.id
1193: AND inst.lse_id = lse.id

Line 1240: okc_line_styles_b b,

1236:
1237: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1238: SELECT c.OBJECT1_ID1
1239: FROM okc_k_lines_b a,
1240: okc_line_styles_b b,
1241: okc_k_items c
1242: WHERE a.cle_id = p_fin_asset_line_id
1243: AND b.lty_code = 'ITEM'
1244: AND a.lse_id = b.id

Line 1284: -- okc_line_styles_b lse

1280:
1281: CURSOR get_top_line ( p_cle_id NUMBER ) IS
1282: select cle.id--, lse.lty_code
1283: from okc_k_lines_b cle--,
1284: -- okc_line_styles_b lse
1285: -- where lse.id = cle.lse_id
1286: -- and cle.cle_id is null
1287: where cle.cle_id is null -- it's top line
1288: start with cle.id = p_cle_id