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_ACTIVATE_IB_PVT dependencies on OKC_K_LINES_B

Line 842: OKC_K_LINES_B MDL,

838: SELECT cim.number_of_items,
839: cim.object1_id1,
840: cim.object1_id2
841: FROM OKC_K_ITEMS CIM,
842: OKC_K_LINES_B MDL,
843: OKC_LINE_STYLES_B MDL_LSE,
844: OKC_K_LINES_B INST
845: WHERE CIM.CLE_ID = MDL.ID
846: AND MDL.CLE_ID = INST.CLE_ID

Line 844: OKC_K_LINES_B INST

840: cim.object1_id2
841: FROM OKC_K_ITEMS CIM,
842: OKC_K_LINES_B MDL,
843: OKC_LINE_STYLES_B MDL_LSE,
844: OKC_K_LINES_B INST
845: WHERE CIM.CLE_ID = MDL.ID
846: AND MDL.CLE_ID = INST.CLE_ID
847: AND MDL.LSE_ID = MDL_LSE.ID
848: AND MDL_LSE.LTY_CODE = G_MODEL_LINE_LTY_CODE

Line 1473: OKC_K_LINES_B MDL,

1469: SELECT cim.number_of_items,
1470: cim.object1_id1,
1471: cim.object1_id2
1472: FROM OKC_K_ITEMS CIM,
1473: OKC_K_LINES_B MDL,
1474: OKC_K_LINES_B INST
1475: WHERE CIM.CLE_ID = MDL.ID
1476: AND MDL.CLE_ID = INST.CLE_ID
1477: AND MDL.LSE_ID = G_MODEL_LINE_LTY_ID

Line 1474: OKC_K_LINES_B INST

1470: cim.object1_id1,
1471: cim.object1_id2
1472: FROM OKC_K_ITEMS CIM,
1473: OKC_K_LINES_B MDL,
1474: OKC_K_LINES_B INST
1475: WHERE CIM.CLE_ID = MDL.ID
1476: AND MDL.CLE_ID = INST.CLE_ID
1477: AND MDL.LSE_ID = G_MODEL_LINE_LTY_ID
1478: AND INST.ID = p_inst_line_id;

Line 1518: FROM OKC_K_LINES_B CLE,

1514: AND NVL(ACTIVE_END_DATE,(p_khr_start_date+1)) > p_khr_start_date
1515: AND ROWNUM = 1
1516: AND NOT EXISTS
1517: (SELECT CLE.DNZ_CHR_ID
1518: FROM OKC_K_LINES_B CLE,
1519: OKC_LINE_STYLES_B CLS,
1520: OKC_K_ITEMS CIM,
1521: OKX_INSTALL_ITEMS_V CIX,
1522: OKL_K_HEADERS KHR

Line 1538: okc_k_lines_b cle

1534: FROM okc_k_headers_b CHR
1535: WHERE chr.id = p_contract_id
1536: AND EXISTS (SELECT '1'
1537: FROM okc_line_styles_b lse,
1538: okc_k_lines_b cle
1539: WHERE cle.sts_code = 'APPROVED'
1540: AND lse.id = cle.lse_id
1541: AND lse.lty_code = 'USAGE'
1542: AND cle.dnz_chr_id = chr.id);

Line 1950: from okc_k_lines_b cle,

1946: --cursor to get ib line
1947: Cursor ib_line_csr(p_chrv_id IN Number) is
1948: SELECT cle.id,
1949: cle.cle_id
1950: from okc_k_lines_b cle,
1951: okc_statuses_b sts -- 4698117
1952: where cle.lse_id = G_IB_LINE_LTY_ID
1953: and cle.dnz_chr_id = p_chrv_id
1954: and cle.sts_code = sts.code

Line 1987: TYPE ib_cle_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;

1983: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
1984: --rkuttiya added for bug #6795295
1985: l_start_date DATE;
1986:
1987: TYPE ib_cle_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
1988: l_ib_cle_id_tbl ib_cle_id_tbl;
1989:
1990: TYPE inst_cle_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
1991: l_inst_cle_id_tbl inst_cle_id_tbl;

Line 1990: TYPE inst_cle_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;

1986:
1987: TYPE ib_cle_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
1988: l_ib_cle_id_tbl ib_cle_id_tbl;
1989:
1990: TYPE inst_cle_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
1991: l_inst_cle_id_tbl inst_cle_id_tbl;
1992:
1993: TYPE ib_inst_rec_type IS RECORD (
1994: ib_cle_id OKC_K_LINES_B.id%TYPE ,

Line 1994: ib_cle_id OKC_K_LINES_B.id%TYPE ,

1990: TYPE inst_cle_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
1991: l_inst_cle_id_tbl inst_cle_id_tbl;
1992:
1993: TYPE ib_inst_rec_type IS RECORD (
1994: ib_cle_id OKC_K_LINES_B.id%TYPE ,
1995: inst_cle_id OKC_K_LINES_B.cle_id %TYPE);
1996:
1997: TYPE ib_inst_tbl_type IS TABLE OF ib_inst_rec_type INDEX BY BINARY_INTEGER;
1998: l_ib_inst_tbl ib_inst_tbl_type;

Line 1995: inst_cle_id OKC_K_LINES_B.cle_id %TYPE);

1991: l_inst_cle_id_tbl inst_cle_id_tbl;
1992:
1993: TYPE ib_inst_rec_type IS RECORD (
1994: ib_cle_id OKC_K_LINES_B.id%TYPE ,
1995: inst_cle_id OKC_K_LINES_B.cle_id %TYPE);
1996:
1997: TYPE ib_inst_tbl_type IS TABLE OF ib_inst_rec_type INDEX BY BINARY_INTEGER;
1998: l_ib_inst_tbl ib_inst_tbl_type;
1999: l_counter NUMBER;

Line 2230: from okc_k_lines_b cle,

2226: Cursor ib_line_csr(p_fin_ast_cle_id IN Number, p_lty_code IN VARCHAR2) is
2227: SELECT cle.id,
2228: cle.cle_id,
2229: cle.dnz_chr_id
2230: from okc_k_lines_b cle,
2231: okc_line_styles_b lse,
2232: okc_k_lines_b inst_cle,
2233: okc_line_styles_b inst_cle_lse
2234: where lse.id = cle.lse_id

Line 2232: okc_k_lines_b inst_cle,

2228: cle.cle_id,
2229: cle.dnz_chr_id
2230: from okc_k_lines_b cle,
2231: okc_line_styles_b lse,
2232: okc_k_lines_b inst_cle,
2233: okc_line_styles_b inst_cle_lse
2234: where lse.id = cle.lse_id
2235: and lse.lty_code = p_lty_code
2236: and cle.cle_id = inst_cle.id

Line 2254: l_ib_cle_id OKC_K_LINES_B.ID%TYPE;

2250: --Bug#2522268
2251: --And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
2252: And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
2253:
2254: l_ib_cle_id OKC_K_LINES_B.ID%TYPE;
2255: l_inst_cle_id OKC_K_LINES_B.ID%TYPE;
2256: l_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
2257:
2258: l_ib_line_lty_code VARCHAR2(200) := G_IB_LINE_LTY_CODE;

Line 2255: l_inst_cle_id OKC_K_LINES_B.ID%TYPE;

2251: --And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
2252: And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
2253:
2254: l_ib_cle_id OKC_K_LINES_B.ID%TYPE;
2255: l_inst_cle_id OKC_K_LINES_B.ID%TYPE;
2256: l_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
2257:
2258: l_ib_line_lty_code VARCHAR2(200) := G_IB_LINE_LTY_CODE;
2259: l_ib_line_count NUMBER default 0;

Line 2256: l_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

2252: And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
2253:
2254: l_ib_cle_id OKC_K_LINES_B.ID%TYPE;
2255: l_inst_cle_id OKC_K_LINES_B.ID%TYPE;
2256: l_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
2257:
2258: l_ib_line_lty_code VARCHAR2(200) := G_IB_LINE_LTY_CODE;
2259: l_ib_line_count NUMBER default 0;
2260: l_cimv_tbl cimv_tbl_type;

Line 2453: ,okc_k_lines_b cle

2449: AND cplb.dnz_chr_id = chr.id
2450: AND cplb.rle_code = 'LESSEE'
2451: AND EXISTS ( SELECT '1'
2452: FROM okl_k_lines kle
2453: ,okc_k_lines_b cle
2454: WHERE cle.dnz_chr_id = chr.id
2455: AND cle.chr_id = chr.id
2456: AND cle.id = kle.id
2457: AND nvl(kle.re_lease_yn,'N') = 'Y')

Line 2474: okc_k_lines_b cleb_ib,

2470: iti.object_id1_new,
2471: trx.id tas_id,
2472: cleb_ib.id cleb_ib_id
2473: From okc_k_items cim_ib,
2474: okc_k_lines_b cleb_ib,
2475: okc_line_styles_b lseb_ib,
2476: okc_statuses_b stsb,
2477: okl_txl_itm_insts iti,
2478: okl_trx_assets trx,

Line 2860: okc_k_lines_b cleb

2856: p_cle_id IN NUMBER) IS
2857: SELECT mtl.serial_number_control_code
2858: FROM mtl_system_items mtl,
2859: okc_k_headers_b chrb,
2860: okc_k_lines_b cleb
2861: WHERE mtl.inventory_item_id = p_inv_item_id
2862: AND mtl.organization_id = chrb.inv_organization_id
2863: AND chrb.id = cleb.dnz_chr_id
2864: AND cleb.id = p_cle_id;

Line 2953: from okc_k_lines_b ib_cle,

2949: Cursor ib_line_csr(p_chrv_id IN Number,
2950: p_fin_ast_cle_id IN Number) is
2951: SELECT ib_cle.id,
2952: ib_cle.cle_id
2953: from okc_k_lines_b ib_cle,
2954: okc_k_lines_b inst_cle,
2955: okc_statuses_b inst_sts
2956: where ib_cle.lse_id = G_IB_LINE_LTY_ID
2957: and ib_cle.dnz_chr_id = p_chrv_id

Line 2954: okc_k_lines_b inst_cle,

2950: p_fin_ast_cle_id IN Number) is
2951: SELECT ib_cle.id,
2952: ib_cle.cle_id
2953: from okc_k_lines_b ib_cle,
2954: okc_k_lines_b inst_cle,
2955: okc_statuses_b inst_sts
2956: where ib_cle.lse_id = G_IB_LINE_LTY_ID
2957: and ib_cle.dnz_chr_id = p_chrv_id
2958: AND inst_sts.code = ib_cle.sts_code

Line 2976: okc_k_lines_b cle

2972: p_fin_ast_cle_id in number) is
2973: select chr.ORIG_SYSTEM_ID1 orig_chr_id,
2974: cle.orig_system_id1 orig_fin_ast_cle_id
2975: from okc_k_headers_b chr,
2976: okc_k_lines_b cle
2977: where chr.id = p_chr_id
2978: and cle.id = p_fin_ast_cle_id
2979: and cle.chr_id = p_chr_id
2980: and cle.dnz_chr_id = p_chr_id;

Line 2991: FROM okc_k_lines_b orig_ib_cle,

2987:
2988: SELECT orig_ib_cle.id orig_ib_cle_id,
2989: orig_ib_cle.cle_id orig_inst_cle_id,
2990: orig_ib_cle.orig_system_id1 rbk_ib_cle_id
2991: FROM okc_k_lines_b orig_ib_cle,
2992: okc_k_lines_b orig_inst_cle,
2993: okc_k_lines_b rbk_inst_cle,
2994: okc_statuses_b inst_sts,
2995: --Bug# 8766336

Line 2992: okc_k_lines_b orig_inst_cle,

2988: SELECT orig_ib_cle.id orig_ib_cle_id,
2989: orig_ib_cle.cle_id orig_inst_cle_id,
2990: orig_ib_cle.orig_system_id1 rbk_ib_cle_id
2991: FROM okc_k_lines_b orig_ib_cle,
2992: okc_k_lines_b orig_inst_cle,
2993: okc_k_lines_b rbk_inst_cle,
2994: okc_statuses_b inst_sts,
2995: --Bug# 8766336
2996: okc_statuses_b rbk_inst_sts

Line 2993: okc_k_lines_b rbk_inst_cle,

2989: orig_ib_cle.cle_id orig_inst_cle_id,
2990: orig_ib_cle.orig_system_id1 rbk_ib_cle_id
2991: FROM okc_k_lines_b orig_ib_cle,
2992: okc_k_lines_b orig_inst_cle,
2993: okc_k_lines_b rbk_inst_cle,
2994: okc_statuses_b inst_sts,
2995: --Bug# 8766336
2996: okc_statuses_b rbk_inst_sts
2997: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id

Line 3023: okc_k_lines_b orig_ib_cle,

3019: SELECT orig_ib_cle.id ib_cle_id,
3020: orig_ib_cle.cle_id inst_cle_id,
3021: orig_ib_cim.object1_id1 instance_id
3022: FROM okc_k_items orig_ib_cim,
3023: okc_k_lines_b orig_ib_cle,
3024: okc_k_lines_b orig_inst_cle,
3025: okc_statuses_b inst_sts
3026: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3027: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id

Line 3024: okc_k_lines_b orig_inst_cle,

3020: orig_ib_cle.cle_id inst_cle_id,
3021: orig_ib_cim.object1_id1 instance_id
3022: FROM okc_k_items orig_ib_cim,
3023: okc_k_lines_b orig_ib_cle,
3024: okc_k_lines_b orig_inst_cle,
3025: okc_statuses_b inst_sts
3026: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3027: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
3028: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID

Line 3039: FROM okc_k_lines_b rbk_inst_cle,

3035: AND inst_sts.code = orig_ib_cle.sts_code
3036: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
3037: AND NOT EXISTS (
3038: SELECT 1
3039: FROM okc_k_lines_b rbk_inst_cle,
3040: okc_statuses_b rbk_inst_sts
3041: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
3042: AND rbk_inst_cle.lse_id = G_INST_LINE_LTY_ID
3043: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id

Line 3059: FROM okc_k_lines_b orig_ib_cle,

3055: rbk_ib_cle.id rbk_ib_cle_id,
3056: rbk_ib_cle.cle_id rbk_inst_cle_id,
3057: TO_NUMBER(ib_cim.object1_id1) instance_id,
3058: ib_cim.id orig_ib_cim_id
3059: FROM okc_k_lines_b orig_ib_cle,
3060: okc_k_lines_b orig_inst_cle,
3061: okc_k_lines_b rbk_inst_cle,
3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,

Line 3060: okc_k_lines_b orig_inst_cle,

3056: rbk_ib_cle.cle_id rbk_inst_cle_id,
3057: TO_NUMBER(ib_cim.object1_id1) instance_id,
3058: ib_cim.id orig_ib_cim_id
3059: FROM okc_k_lines_b orig_ib_cle,
3060: okc_k_lines_b orig_inst_cle,
3061: okc_k_lines_b rbk_inst_cle,
3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,
3064: okc_k_items ib_cim,

Line 3061: okc_k_lines_b rbk_inst_cle,

3057: TO_NUMBER(ib_cim.object1_id1) instance_id,
3058: ib_cim.id orig_ib_cim_id
3059: FROM okc_k_lines_b orig_ib_cle,
3060: okc_k_lines_b orig_inst_cle,
3061: okc_k_lines_b rbk_inst_cle,
3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,
3064: okc_k_items ib_cim,
3065: --Bug# 8766336

Line 3062: okc_k_lines_b rbk_ib_cle,

3058: ib_cim.id orig_ib_cim_id
3059: FROM okc_k_lines_b orig_ib_cle,
3060: okc_k_lines_b orig_inst_cle,
3061: okc_k_lines_b rbk_inst_cle,
3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,
3064: okc_k_items ib_cim,
3065: --Bug# 8766336
3066: okc_statuses_b rbk_inst_sts

Line 3117: okc_k_lines_b ib_cle,

3113: p_chr_id IN NUMBER) is
3114: SELECT csi_item.inventory_item_id
3115: FROM csi_item_instances csi_item,
3116: okc_k_items ib_cim,
3117: okc_k_lines_b ib_cle,
3118: okc_k_lines_b inst_cle,
3119: okc_statuses_b inst_sts
3120: WHERE ib_cim.cle_id = ib_cle.id
3121: AND ib_cim.dnz_chr_id = p_chr_id

Line 3118: okc_k_lines_b inst_cle,

3114: SELECT csi_item.inventory_item_id
3115: FROM csi_item_instances csi_item,
3116: okc_k_items ib_cim,
3117: okc_k_lines_b ib_cle,
3118: okc_k_lines_b inst_cle,
3119: okc_statuses_b inst_sts
3120: WHERE ib_cim.cle_id = ib_cle.id
3121: AND ib_cim.dnz_chr_id = p_chr_id
3122: AND inst_cle.cle_id = p_fin_ast_cle_id

Line 3138: OKC_K_LINES_B MDL,

3134: SELECT cim.number_of_items,
3135: cim.object1_id1,
3136: cim.object1_id2
3137: FROM OKC_K_ITEMS CIM,
3138: OKC_K_LINES_B MDL,
3139: OKC_LINE_STYLES_B MDL_LSE
3140: WHERE CIM.CLE_ID = MDL.ID
3141: AND MDL.CLE_ID = p_fin_ast_cle_id
3142: AND MDL.LSE_ID = MDL_LSE.ID

Line 3160: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;

3156: l_rbk_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
3157: -- gboomina Bug 5362977 - End
3158:
3159: l_orig_k_id okc_k_headers_b.id%type;
3160: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3161: l_instance_id okc_k_items.id%type;
3162: l_instance_cle_id okc_k_items.cle_id%type;
3163:
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;

Line 3192: ib_line_id okc_k_lines_b.id%type;

3188: -- gboomina Bug 5362977 - End
3189:
3190: l_trx_type VARCHAR2(30) := G_TRX_LINE_TYPE_REBOOK;
3191:
3192: ib_line_id okc_k_lines_b.id%type;
3193: ib_line_cle_id okc_k_lines_b.cle_id%type;
3194:
3195: rbk_ib_line_id okc_k_lines_b.id%type;
3196: rbk_ib_line_cle_id okc_k_lines_b.cle_id%type;

Line 3193: ib_line_cle_id okc_k_lines_b.cle_id%type;

3189:
3190: l_trx_type VARCHAR2(30) := G_TRX_LINE_TYPE_REBOOK;
3191:
3192: ib_line_id okc_k_lines_b.id%type;
3193: ib_line_cle_id okc_k_lines_b.cle_id%type;
3194:
3195: rbk_ib_line_id okc_k_lines_b.id%type;
3196: rbk_ib_line_cle_id okc_k_lines_b.cle_id%type;
3197:

Line 3195: rbk_ib_line_id okc_k_lines_b.id%type;

3191:
3192: ib_line_id okc_k_lines_b.id%type;
3193: ib_line_cle_id okc_k_lines_b.cle_id%type;
3194:
3195: rbk_ib_line_id okc_k_lines_b.id%type;
3196: rbk_ib_line_cle_id okc_k_lines_b.cle_id%type;
3197:
3198: l_party_tbl party_tbl_type;
3199: l_party_account NUMBER;

Line 3196: rbk_ib_line_cle_id okc_k_lines_b.cle_id%type;

3192: ib_line_id okc_k_lines_b.id%type;
3193: ib_line_cle_id okc_k_lines_b.cle_id%type;
3194:
3195: rbk_ib_line_id okc_k_lines_b.id%type;
3196: rbk_ib_line_cle_id okc_k_lines_b.cle_id%type;
3197:
3198: l_party_tbl party_tbl_type;
3199: l_party_account NUMBER;
3200: l_inv_mstr_org_id NUMBER;