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 307: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

303: l_api_name CONSTANT VARCHAR2(30) := 'get_split_round_amount';
304: l_api_version CONSTANT NUMBER := 1.0;
305:
306: --Fix Bug# 2727161
307: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
308: SELECT currency_code
309: FROM okc_k_headers_b
310: WHERE id = p_chr_id;
311:

Line 309: FROM okc_k_headers_b

305:
306: --Fix Bug# 2727161
307: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
308: SELECT currency_code
309: FROM okc_k_headers_b
310: WHERE id = p_chr_id;
311:
312: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
313: SELECT h.currency_code

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

308: SELECT currency_code
309: FROM okc_k_headers_b
310: WHERE id = p_chr_id;
311:
312: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
313: SELECT h.currency_code
314: FROM okc_k_headers_b h,
315: okc_k_lines_b l
316: WHERE h.id = l.dnz_chr_id

Line 314: FROM okc_k_headers_b h,

310: WHERE id = p_chr_id;
311:
312: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
313: SELECT h.currency_code
314: FROM okc_k_headers_b h,
315: okc_k_lines_b l
316: WHERE h.id = l.dnz_chr_id
317: AND l.id = p_line_id;
318:

Line 2655: FROM okc_k_headers_b chrb

2651: SELECT 'Y' date_valid,
2652: TO_CHAR(chrb.start_date,pdateformat) con_start_date,
2653: TO_CHAR(chrb.end_date,pdateformat) con_end_date,
2654: chrb.sts_code sts_code
2655: FROM okc_k_headers_b chrb
2656: WHERE ptrxdate BETWEEN TRUNC(chrb.start_date) AND TRUNC(chrb.end_date)
2657: AND chrb.id = pchrid;
2658:
2659: l_chrb_rec l_chrb_csr%ROWTYPE;

Line 3698: OKC_K_HEADERS_B CHR

3694: AND lse.lty_code = G_FIN_AST_LTY_CODE
3695: AND lse.lse_type = G_TOP_LINE_STYLE)
3696: AND EXISTS (SELECT '1'
3697: FROM OKC_SUBCLASS_TOP_LINE stl,
3698: OKC_K_HEADERS_B CHR
3699: WHERE stl.lse_id = cle.lse_id
3700: AND stl.scs_code = CHR.scs_code
3701: AND CHR.id = cle.chr_id);
3702: l_chk_top_line VARCHAR2(1) DEFAULT 'N';

Line 4222: okc_k_headers_b chrb

4218: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
4219: p_chr_id IN NUMBER) IS
4220: SELECT mtl.serial_number_control_code
4221: FROM mtl_system_items mtl,
4222: okc_k_headers_b chrb
4223: WHERE mtl.inventory_item_id = p_inv_item_id
4224: AND mtl.organization_id = chrb.inv_organization_id
4225: --BUG# 3489089
4226: AND chrb.id = p_chr_id;

Line 4233: okc_k_headers_b chrb,

4229: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
4230: p_cle_id IN NUMBER) IS
4231: SELECT mtl.serial_number_control_code
4232: FROM mtl_system_items mtl,
4233: okc_k_headers_b chrb,
4234: okc_k_lines_b cleb
4235: WHERE mtl.inventory_item_id = p_inv_item_id
4236: AND mtl.organization_id = chrb.inv_organization_id
4237: AND chrb.id = cleb.dnz_chr_id

Line 4664: okc_k_headers_b chrb,

4660: SELECT mp.master_organization_id,
4661: chrb.inv_organization_id,
4662: txdb.inventory_item_id
4663: FROM mtl_parameters mp,
4664: okc_k_headers_b chrb,
4665: okc_k_lines_b cleb,
4666: okl_txl_Assets_b txlb,
4667: okl_txd_assets_b txdb
4668: WHERE mp.organization_id = chrb.inv_organization_id

Line 4675: l_inv_org_id okc_k_headers_b.inv_organization_id%TYPE;

4671: AND txlb.id = p_tal_id
4672: AND txdb.id = p_asd_id;
4673:
4674: l_mast_org_id mtl_parameters.master_organization_id%TYPE;
4675: l_inv_org_id okc_k_headers_b.inv_organization_id%TYPE;
4676: l_inv_item_id okl_txd_assets_b.inventory_item_id%TYPE;
4677:
4678: --Cursor to get location of parent instance from IB
4679: CURSOR ib_loc_csr (p_tal_id IN NUMBER) IS

Line 5695: okc_k_headers_b chrb,

5691: --cursor to get deal type
5692: CURSOR l_dealtyp_csr(PCleId IN NUMBER) IS
5693: SELECT khr.deal_type
5694: FROM okl_k_headers khr,
5695: okc_k_headers_b chrb,
5696: okc_k_lines_b cleb
5697: WHERE khr.id = chrb.id
5698: AND chrb.id = cleb.dnz_chr_id
5699: AND cleb.id = PCleId;

Line 5908: okc_k_headers_b oks_chrb,

5904: WHERE EXISTS
5905: (
5906: SELECT '1'
5907: FROM
5908: okc_k_headers_b oks_chrb,
5909: okc_line_styles_b oks_cov_pd_lse,
5910: okc_k_lines_b oks_cov_pd_cleb,
5911: okc_k_rel_objs krel,
5912: okc_line_styles_b lnk_srv_lse,

Line 5953: l_chr_id okc_k_headers_b.id%TYPE;

5949: SELECT dnz_chr_id
5950: FROM okc_k_lines_b
5951: WHERE id = p_cle_id;
5952:
5953: l_chr_id okc_k_headers_b.id%TYPE;
5954:
5955: --cursor to check if contract has re-lease assets
5956: -- Bug# 4631549
5957: -- Disable split asset process for

Line 5988: FROM OKC_K_HEADERS_B

5984:
5985: --Added by dpsingh for LE uptake
5986: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
5987: SELECT contract_number
5988: FROM OKC_K_HEADERS_B
5989: WHERE id = p_ctr_id1;
5990:
5991: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
5992: l_legal_entity_id NUMBER;

Line 5991: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

5987: SELECT contract_number
5988: FROM OKC_K_HEADERS_B
5989: WHERE id = p_ctr_id1;
5990:
5991: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
5992: l_legal_entity_id NUMBER;
5993:
5994: BEGIN
5995: --dbms_output.put_line('before start activity');

Line 10694: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

10690: SELECT book_class
10691: FROM okx_asst_bk_controls_v
10692: WHERE book_type_code = p_book_type_code;
10693: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
10694: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
10695: l_scs_code Varchar2(30);
10696: l_sts_code Varchar2(30);
10697: l_deal_type Varchar2(30);
10698: l_pdt_id Number;

Line 11100: OKC_K_HEADERS_B chr

11096: khr.PDT_ID,
11097: chr.START_DATE
11098: FROM okc_k_lines_b cleb,
11099: okl_k_headers khr,
11100: OKC_K_HEADERS_B chr
11101: WHERE cleb.id = pcleid
11102: and khr.id = cleb.dnz_chr_id
11103: and chr.id = khr.id;
11104: l_cle_status okc_k_lines_b.sts_code%TYPE;

Line 12301: OKC_K_HEADERS_B chr

12297: khr.PDT_ID,
12298: chr.START_DATE
12299: FROM okc_k_lines_b cleb,
12300: okl_k_headers khr,
12301: OKC_K_HEADERS_B chr
12302: WHERE cleb.id = pcleid
12303: and khr.id = cleb.dnz_chr_id
12304: and chr.id = khr.id;
12305: l_cle_status okc_k_lines_b.sts_code%TYPE;

Line 13271: FROM OKC_K_HEADERS_B chrb

13267: --------------------------------------Bug# 3124577 : 11.5.10 Rule Migration----*/
13268:
13269: CURSOR party_account_csr(p_chrv_id IN NUMBER) IS
13270: SELECT chrb.cust_acct_id
13271: FROM OKC_K_HEADERS_B chrb
13272: WHERE chrb.id = p_chrv_id;
13273:
13274: l_party_account NUMBER;
13275:

Line 14904: from okc_k_headers_b chrb

14900: --Bug# 4631549
14901: --cursor to fetch re-lease contract flag
14902: cursor l_chrb_csr (p_chr_id in number) is
14903: select chrb.orig_system_source_code
14904: from okc_k_headers_b chrb
14905: where chrb.id = p_chr_id;
14906:
14907: l_chrb_rec l_chrb_csr%ROWTYPE;
14908:

Line 16136: okc_k_headers_b CHR,

16132: CURSOR srl_ctrl_csr (PInvItmId IN NUMBER,
16133: P_fin_ast_id IN NUMBER) IS
16134: SELECT mtl.serial_number_control_code
16135: FROM mtl_system_items mtl,
16136: okc_k_headers_b CHR,
16137: okc_k_lines_b cle
16138: WHERE mtl.inventory_item_id = PInvItmId
16139: AND mtl.organization_id = CHR.INV_ORGANIZATION_ID
16140: AND CHR.id = cle.chr_id