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_SPLIT_ASSET_PVT dependencies on OKC_K_HEADERS_B

Line 314: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

310: l_api_name CONSTANT VARCHAR2(30) := 'get_split_round_amount';
311: l_api_version CONSTANT NUMBER := 1.0;
312:
313: --Fix Bug# 2727161
314: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
315: SELECT currency_code
316: FROM okc_k_headers_b
317: WHERE id = p_chr_id;
318:

Line 316: FROM okc_k_headers_b

312:
313: --Fix Bug# 2727161
314: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
315: SELECT currency_code
316: FROM okc_k_headers_b
317: WHERE id = p_chr_id;
318:
319: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
320: SELECT h.currency_code

Line 319: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS

315: SELECT currency_code
316: FROM okc_k_headers_b
317: WHERE id = p_chr_id;
318:
319: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
320: SELECT h.currency_code
321: FROM okc_k_headers_b h,
322: okc_k_lines_b l
323: WHERE h.id = l.dnz_chr_id

Line 321: FROM okc_k_headers_b h,

317: WHERE id = p_chr_id;
318:
319: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
320: SELECT h.currency_code
321: FROM okc_k_headers_b h,
322: okc_k_lines_b l
323: WHERE h.id = l.dnz_chr_id
324: AND l.id = p_line_id;
325:

Line 2683: FROM okc_k_headers_b chrb

2679: SELECT 'Y' date_valid,
2680: TO_CHAR(chrb.start_date,pdateformat) con_start_date,
2681: TO_CHAR(chrb.end_date,pdateformat) con_end_date,
2682: chrb.sts_code sts_code
2683: FROM okc_k_headers_b chrb
2684: WHERE ptrxdate BETWEEN TRUNC(chrb.start_date) AND TRUNC(chrb.end_date)
2685: AND chrb.id = pchrid;
2686:
2687: l_chrb_rec l_chrb_csr%ROWTYPE;

Line 3726: OKC_K_HEADERS_B CHR

3722: AND lse.lty_code = G_FIN_AST_LTY_CODE
3723: AND lse.lse_type = G_TOP_LINE_STYLE)
3724: AND EXISTS (SELECT '1'
3725: FROM OKC_SUBCLASS_TOP_LINE stl,
3726: OKC_K_HEADERS_B CHR
3727: WHERE stl.lse_id = cle.lse_id
3728: AND stl.scs_code = CHR.scs_code
3729: AND CHR.id = cle.chr_id);
3730: l_chk_top_line VARCHAR2(1) DEFAULT 'N';

Line 4250: okc_k_headers_b chrb

4246: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
4247: p_chr_id IN NUMBER) IS
4248: SELECT mtl.serial_number_control_code
4249: FROM mtl_system_items mtl,
4250: okc_k_headers_b chrb
4251: WHERE mtl.inventory_item_id = p_inv_item_id
4252: AND mtl.organization_id = chrb.inv_organization_id
4253: --BUG# 3489089
4254: AND chrb.id = p_chr_id;

Line 4261: okc_k_headers_b chrb,

4257: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
4258: p_cle_id IN NUMBER) IS
4259: SELECT mtl.serial_number_control_code
4260: FROM mtl_system_items mtl,
4261: okc_k_headers_b chrb,
4262: okc_k_lines_b cleb
4263: WHERE mtl.inventory_item_id = p_inv_item_id
4264: AND mtl.organization_id = chrb.inv_organization_id
4265: AND chrb.id = cleb.dnz_chr_id

Line 4692: okc_k_headers_b chrb,

4688: SELECT mp.master_organization_id,
4689: chrb.inv_organization_id,
4690: txdb.inventory_item_id
4691: FROM mtl_parameters mp,
4692: okc_k_headers_b chrb,
4693: okc_k_lines_b cleb,
4694: okl_txl_Assets_b txlb,
4695: okl_txd_assets_b txdb
4696: WHERE mp.organization_id = chrb.inv_organization_id

Line 4703: l_inv_org_id okc_k_headers_b.inv_organization_id%TYPE;

4699: AND txlb.id = p_tal_id
4700: AND txdb.id = p_asd_id;
4701:
4702: l_mast_org_id mtl_parameters.master_organization_id%TYPE;
4703: l_inv_org_id okc_k_headers_b.inv_organization_id%TYPE;
4704: l_inv_item_id okl_txd_assets_b.inventory_item_id%TYPE;
4705:
4706: --Cursor to get location of parent instance from IB
4707: CURSOR ib_loc_csr (p_tal_id IN NUMBER) IS

Line 5723: okc_k_headers_b chrb,

5719: --cursor to get deal type
5720: CURSOR l_dealtyp_csr(PCleId IN NUMBER) IS
5721: SELECT khr.deal_type
5722: FROM okl_k_headers khr,
5723: okc_k_headers_b chrb,
5724: okc_k_lines_b cleb
5725: WHERE khr.id = chrb.id
5726: AND chrb.id = cleb.dnz_chr_id
5727: AND cleb.id = PCleId;

Line 5936: okc_k_headers_b oks_chrb,

5932: WHERE EXISTS
5933: (
5934: SELECT '1'
5935: FROM
5936: okc_k_headers_b oks_chrb,
5937: okc_line_styles_b oks_cov_pd_lse,
5938: okc_k_lines_b oks_cov_pd_cleb,
5939: okc_k_rel_objs krel,
5940: okc_line_styles_b lnk_srv_lse,

Line 5981: l_chr_id okc_k_headers_b.id%TYPE;

5977: SELECT dnz_chr_id
5978: FROM okc_k_lines_b
5979: WHERE id = p_cle_id;
5980:
5981: l_chr_id okc_k_headers_b.id%TYPE;
5982:
5983: --cursor to check if contract has re-lease assets
5984: -- Bug# 4631549
5985: -- Disable split asset process for

Line 6002: FROM OKC_K_HEADERS_B chr

5998: */
5999:
6000:
6001: SELECT NVL(kle.re_lease_yn,'N')
6002: FROM OKC_K_HEADERS_B chr
6003: ,okc_k_lines_b cle
6004: ,okl_k_lines kle
6005: WHERE chr.id = cle.chr_id
6006: and chr.id = cle.dnz_chr_id

Line 6036: FROM OKC_K_HEADERS_B

6032:
6033: --Added by dpsingh for LE uptake
6034: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
6035: SELECT contract_number
6036: FROM OKC_K_HEADERS_B
6037: WHERE id = p_ctr_id1;
6038:
6039: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
6040: l_legal_entity_id NUMBER;

Line 6039: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

6035: SELECT contract_number
6036: FROM OKC_K_HEADERS_B
6037: WHERE id = p_ctr_id1;
6038:
6039: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
6040: l_legal_entity_id NUMBER;
6041:
6042: BEGIN
6043: --dbms_output.put_line('before start activity');

Line 10747: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

10743: SELECT book_class
10744: FROM okx_asst_bk_controls_v
10745: WHERE book_type_code = p_book_type_code;
10746: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
10747: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
10748: l_scs_code Varchar2(30);
10749: l_sts_code Varchar2(30);
10750: l_deal_type Varchar2(30);
10751: l_pdt_id Number;

Line 11153: OKC_K_HEADERS_B chr

11149: khr.PDT_ID,
11150: chr.START_DATE
11151: FROM okc_k_lines_b cleb,
11152: okl_k_headers khr,
11153: OKC_K_HEADERS_B chr
11154: WHERE cleb.id = pcleid
11155: and khr.id = cleb.dnz_chr_id
11156: and chr.id = khr.id;
11157: l_cle_status okc_k_lines_b.sts_code%TYPE;

Line 12354: OKC_K_HEADERS_B chr

12350: khr.PDT_ID,
12351: chr.START_DATE
12352: FROM okc_k_lines_b cleb,
12353: okl_k_headers khr,
12354: OKC_K_HEADERS_B chr
12355: WHERE cleb.id = pcleid
12356: and khr.id = cleb.dnz_chr_id
12357: and chr.id = khr.id;
12358: l_cle_status okc_k_lines_b.sts_code%TYPE;

Line 13324: FROM OKC_K_HEADERS_B chrb

13320: --------------------------------------Bug# 3124577 : 11.5.10 Rule Migration----*/
13321:
13322: CURSOR party_account_csr(p_chrv_id IN NUMBER) IS
13323: SELECT chrb.cust_acct_id
13324: FROM OKC_K_HEADERS_B chrb
13325: WHERE chrb.id = p_chrv_id;
13326:
13327: l_party_account NUMBER;
13328:

Line 14957: from okc_k_headers_b chrb

14953: --Bug# 4631549
14954: --cursor to fetch re-lease contract flag
14955: cursor l_chrb_csr (p_chr_id in number) is
14956: select chrb.orig_system_source_code
14957: from okc_k_headers_b chrb
14958: where chrb.id = p_chr_id;
14959:
14960: l_chrb_rec l_chrb_csr%ROWTYPE;
14961:

Line 16228: okc_k_headers_b CHR,

16224: CURSOR srl_ctrl_csr (PInvItmId IN NUMBER,
16225: P_fin_ast_id IN NUMBER) IS
16226: SELECT mtl.serial_number_control_code
16227: FROM mtl_system_items mtl,
16228: okc_k_headers_b CHR,
16229: okc_k_lines_b cle
16230: WHERE mtl.inventory_item_id = PInvItmId
16231: AND mtl.organization_id = CHR.INV_ORGANIZATION_ID
16232: AND CHR.id = cle.chr_id