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_K_LINES_B

Line 63: from okc_k_lines_b

59: l_khr_id okc_k_headers_b.id%type;
60:
61: CURSOR get_chr_id (p_kle_id NUMBER) IS
62: select dnz_chr_id
63: from okc_k_lines_b
64: where id = p_kle_id;
65:
66: /*
67: --added for rules migration

Line 84: , okc_k_lines_b cle

80: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
81: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
82: FROM okc_k_headers_b khr
83: , okx_cust_site_uses_v cs
84: , okc_k_lines_b cle
85: , hz_customer_profiles cp
86: WHERE khr.id = p_khr_id
87: AND cle.dnz_chr_id = khr.id
88: AND cle.chr_id IS NOT NULL

Line 95: , okc_k_lines_b cle

91: AND khr.bill_to_site_use_id = cp.site_use_id(+)
92: UNION
93: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
94: FROM okc_k_headers_b khr
95: , okc_k_lines_b cle
96: , okc_k_items item
97: , okc_k_lines_b linked_asset
98: , okx_cust_site_uses_v cs
99: , hz_customer_profiles cp

Line 97: , okc_k_lines_b linked_asset

93: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
94: FROM okc_k_headers_b khr
95: , okc_k_lines_b cle
96: , okc_k_items item
97: , okc_k_lines_b linked_asset
98: , okx_cust_site_uses_v cs
99: , hz_customer_profiles cp
100: WHERE khr.id = p_khr_id
101: AND cle.dnz_chr_id = khr.id

Line 131: FROM okc_k_lines_b cle

127: rul.rule_information_category = 'LAPMTH' AND
128: rgp.dnz_chr_id = p_khr_id
129: UNION
130: SELECT rul.object1_id1
131: FROM okc_k_lines_b cle
132: , okc_k_items_v item
133: , okc_k_lines_b linked_asset
134: , OKC_RULES_B rul
135: , Okc_rule_groups_B rgp

Line 133: , okc_k_lines_b linked_asset

129: UNION
130: SELECT rul.object1_id1
131: FROM okc_k_lines_b cle
132: , okc_k_items_v item
133: , okc_k_lines_b linked_asset
134: , OKC_RULES_B rul
135: , Okc_rule_groups_B rgp
136: WHERE cle.dnz_chr_id = p_khr_id AND
137: cle.id = p_kle_id AND

Line 169: FROM okc_k_lines_b cle

165: rul.rule_information_category = 'LABACC' AND
166: rgp.dnz_chr_id = p_khr_id
167: UNION
168: SELECT rul.object1_id1
169: FROM okc_k_lines_b cle
170: , okc_k_items_v item
171: , okc_k_lines_b linked_asset
172: , OKC_RULES_B rul
173: , Okc_rule_groups_B rgp

Line 171: , okc_k_lines_b linked_asset

167: UNION
168: SELECT rul.object1_id1
169: FROM okc_k_lines_b cle
170: , okc_k_items_v item
171: , okc_k_lines_b linked_asset
172: , OKC_RULES_B rul
173: , Okc_rule_groups_B rgp
174: WHERE cle.dnz_chr_id = p_khr_id AND
175: cle.id = p_kle_id AND

Line 669: l_chr_id okc_k_lines_b.chr_id%TYPE;

665:
666: l_ship_to NUMBER;
667: l_kle_id NUMBER;
668: l_top_kle_id NUMBER;
669: l_chr_id okc_k_lines_b.chr_id%TYPE;
670: l_asset_name okc_k_lines_v.name%TYPE;
671: l_install_location_id NUMBER;
672: l_location_id NUMBER;
673: --start: 02-APR-07 cklee R12 Billing enhancement project |

Line 687: FROM okc_k_lines_b

683: WHERE id = p_lsm_id;
684:
685: CURSOR check_top_line ( p_cle_id NUMBER ) IS
686: SELECT chr_id
687: FROM okc_k_lines_b
688: where id = p_cle_id;
689:
690: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
691: SELECT FA.ID

Line 693: OKC_K_LINES_B TOP_CLE,

689:
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,

Line 695: OKC_K_LINES_B SUB_CLE,

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,
699: OKC_LINE_STYLES_B AST_LSE,

Line 731: okc_k_lines_b inst,

727: csi.install_location_id
728: , csi.location_id
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

Line 732: okc_k_lines_b ib,

728: , csi.location_id
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

Line 781: FROM okc_k_lines_b kle

777: is_top_line_flag boolean;
778:
779: CURSOR is_top_line ( p_cle_id NUMBER ) IS
780: SELECT 1
781: FROM okc_k_lines_b kle
782: where kle.id = p_cle_id
783: and kle.cle_id is null; -- it's top line
784:
785: CURSOR get_top_line ( p_cle_id NUMBER ) IS

Line 787: from okc_k_lines_b cle--,

783: and kle.cle_id is null; -- it's top line
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

Line 1128: l_chr_id okc_k_lines_b.chr_id%TYPE;

1124:
1125: l_ship_to NUMBER;
1126: l_kle_id NUMBER;
1127: l_top_kle_id NUMBER;
1128: l_chr_id okc_k_lines_b.chr_id%TYPE;
1129: l_asset_name okc_k_lines_v.name%TYPE;
1130: l_install_location_id NUMBER;
1131: l_location_id NUMBER;
1132: --start: 02-APR-07 cklee R12 Billing enhancement project |

Line 1143: FROM okc_k_lines_b

1139: WHERE id = p_lsm_id;
1140:
1141: CURSOR check_top_line ( p_cle_id NUMBER ) IS
1142: SELECT chr_id
1143: FROM okc_k_lines_b
1144: where id = p_cle_id;
1145:
1146: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
1147: SELECT FA.ID

Line 1149: OKC_K_LINES_B TOP_CLE,

1145:
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,

Line 1151: OKC_K_LINES_B SUB_CLE,

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,
1155: OKC_LINE_STYLES_B AST_LSE,

Line 1187: okc_k_lines_b inst,

1183: csi.install_location_id
1184: , csi.location_id
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

Line 1188: okc_k_lines_b ib,

1184: , csi.location_id
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

Line 1239: FROM okc_k_lines_b a,

1235: l_uom_code mtl_system_items.primary_uom_code%TYPE;
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'

Line 1277: FROM okc_k_lines_b kle

1273: is_top_line_flag boolean;
1274:
1275: CURSOR is_top_line ( p_cle_id NUMBER ) IS
1276: SELECT 1
1277: FROM okc_k_lines_b kle
1278: where kle.id = p_cle_id
1279: and kle.cle_id is null; -- it's top line
1280:
1281: CURSOR get_top_line ( p_cle_id NUMBER ) IS

Line 1283: from okc_k_lines_b cle--,

1279: and kle.cle_id is null; -- it's top line
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