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 OKL_TXD_ASSETS_B

Line 337: FROM okl_txd_assets_b txd,

333: txl.kle_id,
334: txd.target_kle_id,
335: txd.quantity,
336: txl.current_units
337: FROM okl_txd_assets_b txd,
338: okl_txl_Assets_b txl
339: WHERE txl.tal_type = 'ALI'
340: AND txd.tal_id = txl.id
341: AND txl.id = p_trxline_id

Line 3451: FROM okl_txd_assets_b txd

3447:
3448: --check for asset on an split asset transaction
3449: CURSOR asset_chk_curs3 (p_asset_number IN VARCHAR2) IS
3450: SELECT 'Y'
3451: FROM okl_txd_assets_b txd
3452: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3453: AND EXISTS (SELECT NULL
3454: FROM okl_trx_Assets trx,
3455: okl_trx_types_tl ttyp,

Line 3538: FROM okl_txd_assets_b txd,

3534:
3535: --check for asset on an split asset transaction
3536: CURSOR asset_chk_curs3 (p_asset_number IN VARCHAR2, p_txdv_id IN NUMBER) IS
3537: SELECT 'Y'
3538: FROM okl_txd_assets_b txd,
3539: okl_txl_assets_b txl,
3540: okl_trx_types_tl ttyp,
3541: okl_trx_assets trx
3542: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number

Line 3961: --Procedure to create split transaction details (okl_txd_assets_b)

3957: x_msg_data,
3958: '_PVT');
3959: END Update_trx_header;
3960: --------------------------------------------------------------------------------
3961: --Procedure to create split transaction details (okl_txd_assets_b)
3962: --Bug# 2798006 : Modifications for Loan contract - instead of reading values from
3963: --p_ast_line_rec will read from p_txlv_rec
3964: --------------------------------------------------------------------------------
3965: PROCEDURE Create_trx_details(p_api_version IN NUMBER,

Line 4695: okl_txd_assets_b txdb

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
4697: AND chrb.id = cleb.dnz_chr_id
4698: AND cleb.id = txlb.kle_id
4699: AND txlb.id = p_tal_id

Line 4704: l_inv_item_id okl_txd_assets_b.inventory_item_id%TYPE;

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
4708: SELECT txlb.kle_id fa_cle_id,

Line 4800: from okl_txd_assets_b

4796:
4797: --Bug # 7047938
4798: cursor l_tal_csr (p_asd_id in number) is
4799: select tal_id
4800: from okl_txd_assets_b
4801: where id = p_asd_id;
4802:
4803: l_tal_id okl_txd_assets_b.tal_id%TYPE;
4804: --Bug 7047938 End

Line 4803: l_tal_id okl_txd_assets_b.tal_id%TYPE;

4799: select tal_id
4800: from okl_txd_assets_b
4801: where id = p_asd_id;
4802:
4803: l_tal_id okl_txd_assets_b.tal_id%TYPE;
4804: --Bug 7047938 End
4805: BEGIN
4806: ----
4807: x_return_status := OKL_API.START_ACTIVITY (

Line 7813: FROM okl_txd_assets_b txd,

7809: cle.cle_id cle_id,
7810: target_cle.cle_id target_cle_id,
7811: txd.quantity,
7812: txl.current_units
7813: FROM okl_txd_assets_b txd,
7814: okl_txl_Assets_b txl,
7815: okc_k_lines_b cle,
7816: okc_k_lines_b target_cle
7817: WHERE txl.tal_type = 'ALI'

Line 7840: FROM okl_txd_assets_b txd,

7836: cle.cle_id cle_id,
7837: target_cle.cle_id target_cle_id,
7838: txd.quantity,
7839: txl.current_units
7840: FROM okl_txd_assets_b txd,
7841: okl_txl_Assets_b txl,
7842: okc_k_lines_b cle,
7843: okc_k_lines_b target_cle
7844: WHERE txl.tal_type = 'ALI'

Line 8036: FROM okl_txd_assets_b txd,

8032: cle.cle_id cle_id,
8033: target_cle.cle_id target_cle_id,
8034: txd.quantity,
8035: txl.current_units
8036: FROM okl_txd_assets_b txd,
8037: okl_txl_Assets_b txl,
8038: okc_k_lines_b cle,
8039: okc_k_lines_b target_cle
8040: WHERE txl.tal_type = 'ALI'

Line 9033: FROM okl_txd_assets_b txd

9029: p_cle_id IN NUMBER) IS
9030: SELECT id,
9031: quantity,
9032: split_percent
9033: FROM okl_txd_assets_b txd
9034: WHERE txd.tal_id = p_tal_id
9035: AND NVL(txd.target_kle_id,-1) <> p_cle_id;
9036:
9037: l_sll_amount NUMBER;

Line 10775: OKL_TXD_ASSETS_B txl

10771: Cursor tax_off_trx_amt(p_asset_id in number, p_tax_book in varchar2) is
10772: select tas.date_trans_occurred
10773: FROM OKL_TRX_ASSETS tas,
10774: OKL_TXL_ASSETS_B tal,
10775: OKL_TXD_ASSETS_B txl
10776: WHERE tas.id = tal.tas_id
10777: AND tal.id = txl.tal_id
10778: AND txl.tax_book = p_tax_book
10779: AND tas.tsu_code = 'PROCESSED'

Line 10787: OKL_TXD_ASSETS_B txd

10783: SELECT
10784: tas.date_trans_occurred
10785: FROM OKL_TRX_ASSETS tas,
10786: OKL_TXL_ASSETS_B tal,
10787: OKL_TXD_ASSETS_B txd
10788: WHERE tas.id = tal.tas_id
10789: AND tal.corporate_book = P_corp_book
10790: AND tas.tsu_code = 'PROCESSED'
10791: AND tas.tas_type in ('AMT')

Line 10799: OKL_TXD_ASSETS_B txl

10795: Cursor tax_off_trx_aus(p_asset_id in number, p_tax_book in varchar2) is
10796: select tas.date_trans_occurred
10797: FROM OKL_TRX_ASSETS tas,
10798: OKL_TXL_ASSETS_B tal,
10799: OKL_TXD_ASSETS_B txl
10800: WHERE tas.id = tal.tas_id
10801: AND tal.id = txl.tal_id
10802: AND txl.tax_book = p_tax_book
10803: AND tas.tsu_code = 'PROCESSED'

Line 10811: OKL_TXD_ASSETS_B txd

10807: SELECT
10808: tas.date_trans_occurred
10809: FROM OKL_TRX_ASSETS tas,
10810: OKL_TXL_ASSETS_B tal,
10811: OKL_TXD_ASSETS_B txd
10812: WHERE tas.id = tal.tas_id
10813: AND tal.corporate_book = P_corp_book
10814: AND tas.tsu_code = 'PROCESSED'
10815: AND tas.tas_type in ('AUS')

Line 11001: -- OKL_TXD_ASSETS_B

10997: -- p_sla_source_try_id IN Number,
10998: -- OKL_TRX_ASSETS.try_id (transaction type id)
10999: -- p_sla_source_line_id IN Number,
11000: -- ID of line table (OKL_TXL_ASSETS_B or
11001: -- OKL_TXD_ASSETS_B
11002: -- p_sla_source_line_table IN Varchar2,
11003: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
11004: -- p_sla_source_chr_id IN Number,
11005: -- Contract id of the contract on which

Line 11003: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B

10999: -- p_sla_source_line_id IN Number,
11000: -- ID of line table (OKL_TXL_ASSETS_B or
11001: -- OKL_TXD_ASSETS_B
11002: -- p_sla_source_line_table IN Varchar2,
11003: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
11004: -- p_sla_source_chr_id IN Number,
11005: -- Contract id of the contract on which
11006: -- source transaction happened
11007: -- p_sla_source_kle_id IN Number,

Line 14098: okl_txd_assets_b txdb

14094: okc_line_styles_b lse_ib,
14095: okc_k_lines_b cle_inst,
14096: okc_line_styles_b lse_inst,
14097: okc_k_lines_b cle_fa,
14098: okl_txd_assets_b txdb
14099: WHERE cle_ib.lse_id = lse_ib.id
14100: AND lse_ib.lty_code = 'INST_ITEM'
14101: AND cle_ib.dnz_chr_id = cle_inst.dnz_chr_id
14102: AND cle_ib.cle_id = cle_inst.id

Line 14117: okl_txd_assets_b txdb

14113: --cursor to fetch child asset top line is
14114: CURSOR child_cle_csr(p_txd_id IN NUMBER) IS
14115: SELECT cle_fa.cle_id
14116: FROM okc_k_lines_b cle_fa,
14117: okl_txd_assets_b txdb
14118: WHERE cle_fa.id = txdb.target_kle_id
14119: AND txdb.id = p_txd_id;
14120:
14121: l_target_cle_id OKC_K_LINES_B.ID%TYPE;

Line 14379: FROM okl_txd_assets_b txdb

14375:
14376: --cursor to fetch child instance lines
14377: CURSOR l_target_kle_csr(p_tal_id IN NUMBER) IS
14378: SELECT txdb.target_kle_id
14379: FROM okl_txd_assets_b txdb
14380: WHERE txdb.tal_id = p_tal_id;
14381:
14382: l_target_kle_id NUMBER DEFAULT 0;
14383:

Line 14725: FROM okl_txd_assets_b txd

14721: cle_id
14722: FROM okc_k_items cim
14723: WHERE EXISTS
14724: (SELECT '1'
14725: FROM okl_txd_assets_b txd
14726: WHERE txd.target_kle_id = cim.cle_id
14727: AND txd.id = p_id
14728: );
14729:

Line 14845: OKL_TXD_ASSETS_B asd

14841: OKC_LINE_STYLES_B inst_item_lse,
14842: OKC_K_LINES_B f_frm2,
14843: OKC_LINE_STYLES_B f_frm2_lse,
14844: OKC_K_LINES_B fa,
14845: OKL_TXD_ASSETS_B asd
14846: WHERE cim.cle_id = inst_item.id
14847: AND cim.dnz_chr_id = inst_item.dnz_chr_id
14848: AND inst_item.cle_id = f_frm2.id
14849: AND inst_item.lse_id = inst_item_lse.id

Line 15461: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',

15457: p_sla_source_header_id => l_txlv_rec.tas_id,
15458: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15459: p_sla_source_try_id => l_trx_rec.try_id,
15460: p_sla_source_line_id => l_txdv_rec.id,
15461: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
15462: p_sla_source_chr_id => l_chr_id,
15463: p_sla_source_kle_id => l_split_cle_id,
15464: p_sla_asset_chr_id => l_sla_asset_chr_id,
15465: --Bug# 6373605--SLA populate sources