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_TXL_ASSETS_B

Line 338: okl_txl_Assets_b txl

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
342: --Bug# 6898798 start

Line 1176: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

1172:
1173: --Cursor to check whether split asset transaction is in progress for the contract
1174: CURSOR check_split_trx_csr IS
1175: SELECT tas.id
1176: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
1177: WHERE txl.tal_type= 'ALI'
1178: AND txl.dnz_khr_id = p_chr_id
1179: AND txl.tas_id = tas.id
1180: AND tas.tas_type = 'ALI'

Line 2564: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

2560:
2561: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
2562: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
2563: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
2564: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
2565: WHERE h.id = l.tas_id
2566: AND h.date_trans_occurred <= cp_trx_date
2567: AND h.tas_type in ('AMT','AUD','AUS')
2568: AND l.asset_number = cp_asset_number;

Line 2571: l_name OKL_TXL_ASSETS_B.asset_number%TYPE;

2567: AND h.tas_type in ('AMT','AUD','AUS')
2568: AND l.asset_number = cp_asset_number;
2569:
2570: l_okxassetlines_rec l_okxassetlines_csr%ROWTYPE;
2571: l_name OKL_TXL_ASSETS_B.asset_number%TYPE;
2572: l_trx_status VARCHAR2(30);
2573:
2574:
2575: BEGIN

Line 3456: okl_txl_assets_b txl

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,
3456: okl_txl_assets_b txl
3457: WHERE trx.id = txl.tas_id
3458: AND trx.try_id = ttyp.id
3459: AND ttyp.name = 'Split Asset'
3460: AND ttyp.LANGUAGE = 'US'

Line 3539: okl_txl_assets_b txl,

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
3543: AND txd.tal_id = txl.id

Line 3555: FROM okl_txl_assets_b txl

3551:
3552: --check for asset on create asset or rebook transaction
3553: CURSOR asset_chk_curs4 (p_asset_number IN VARCHAR2) IS
3554: SELECT 'Y'
3555: FROM okl_txl_assets_b txl
3556: WHERE txl.asset_number = p_asset_number
3557: AND txl.tal_type IN ('ALI','CRB'); --only transactions apart from split which create a new line
3558:
3559:

Line 4694: okl_txl_Assets_b txlb,

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

Line 4726: okl_txl_assets_b txlb

4722: okc_line_styles_b inst_lse,
4723: okc_statuses_b inst_sts,
4724: okc_k_lines_b fa_cle,
4725: okc_line_styles_b fa_lse,
4726: okl_txl_assets_b txlb
4727: WHERE csi.instance_id = TO_NUMBER(ib_cim.object1_id1)
4728: AND csi_inst_sts.instance_status_id = csi.instance_status_id
4729: AND NVL(csi_inst_sts.terminated_flag,'N') = 'N'
4730: AND ib_cim.cle_id = ib_cle.id

Line 4749: l_tas_id okl_txl_assets_b.tas_id%TYPE;

4745: AND txlb.id = p_tal_id;
4746:
4747: l_fa_cle_id okc_k_lines_b.id%TYPE;
4748: l_ib_cle_id okc_k_lines_b.id%TYPE;
4749: l_tas_id okl_txl_assets_b.tas_id%TYPE;
4750: l_location_id csi_item_instances.location_id%TYPE;
4751: l_install_location_id csi_item_instances.install_location_id%TYPE;
4752: --BUG# 3569441
4753: l_location_type_code csi_item_instances.install_location_type_code%TYPE;

Line 5069: FROM okl_txl_assets_b txl

5065:
5066: --cursor to get txl quantity
5067: CURSOR l_txlqty_csr (p_tal_id IN NUMBER) IS
5068: SELECT txl.current_units
5069: FROM okl_txl_assets_b txl
5070: WHERE id = p_tal_id;
5071:
5072: l_txlqty NUMBER DEFAULT NULL;
5073:

Line 5806: FROM OKL_TXL_ASSETS_B txl,

5802: txl.SPLIT_INTO_UNITS, --p_split_into_units
5803: --Bug# 3156924
5804: tas.DATE_TRANS_OCCURRED,
5805: tas.ID
5806: FROM OKL_TXL_ASSETS_B txl,
5807: OKL_TRX_ASSETS tas
5808: WHERE txl.kle_id = p_cle_id
5809: AND txl.tas_id = tas.id
5810: AND txl.tal_type = 'ALI'

Line 7814: okl_txl_Assets_b txl,

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'
7818: AND txd.tal_id = txl.id

Line 7841: okl_txl_Assets_b txl,

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'
7845: AND txd.tal_id = txl.id

Line 8037: okl_txl_Assets_b txl,

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'
8041: AND txd.tal_id = txl.id

Line 10774: OKL_TXL_ASSETS_B tal,

10770: -- CURSOR TO GET MAX OFF LEASE TRX DATESELECT
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

Line 10786: OKL_TXL_ASSETS_B tal,

10782: Cursor corp_off_trx_amt(p_asset_id in number, p_corp_book in varchar2) is
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'

Line 10798: OKL_TXL_ASSETS_B tal,

10794: AND TAX_BOOK IS NULL ;
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

Line 10810: OKL_TXL_ASSETS_B tal,

10806: Cursor corp_off_trx_aus(p_asset_id in number, p_corp_book in varchar2) is
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'

Line 11000: -- ID of line table (OKL_TXL_ASSETS_B or

10996: -- 'OKL_TRX_ASSETS'
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,

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 13365: okl_txl_Assets_b tal

13361: okc_k_lines_b inst_cle,
13362: okc_line_styles_b inst_lse,
13363: okc_k_lines_b fa_cle,
13364: okc_line_styles_b fa_lse,
13365: okl_txl_Assets_b tal
13366: WHERE ib_cim.object1_id1 = TO_CHAR(PInstanceId)
13367: AND ib_cim.object1_id2 = '#'
13368: AND ib_cim.jtot_object1_code = 'OKX_IB_ITEM'
13369: AND ib_cim.cle_id = ib_cle.id

Line 14863: OKL_TXL_ASSETS_B tal

14859: OKC_LINE_STYLES_B inst_item_lse_p,
14860: OKC_K_LINES_B f_frm2_p,
14861: OKC_LINE_STYLES_B f_frm2_lse_p,
14862: OKC_K_LINES_B fa_p,
14863: OKL_TXL_ASSETS_B tal
14864: WHERE cim_p.object1_id1 = cim.object1_id1
14865: AND cim_p.object1_id2 = cim.object1_id2
14866: AND cim_p.jtot_object1_code = cim.jtot_object1_code
14867: AND cim_p.dnz_chr_id = cim.dnz_chr_id

Line 15286: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

15282: p_sla_source_header_id => l_txlv_rec.tas_id,
15283: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15284: p_sla_source_try_id => l_trx_rec.try_id,
15285: p_sla_source_line_id => l_txlv_rec.id,
15286: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
15287: p_sla_source_chr_id => l_chr_id,
15288: p_sla_source_kle_id => l_source_cle_id,
15289: --Bug# 6373605--SLA populate sources
15290: --Bug# 4028371

Line 15805: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',

15801: p_sla_source_header_id => l_txlv_rec.tas_id,
15802: p_sla_source_header_table => 'OKL_TRX_ASSETS',
15803: p_sla_source_try_id => l_trx_rec.try_id,
15804: p_sla_source_line_id => l_txlv_rec.id,
15805: p_sla_source_line_table => 'OKL_TXL_ASSETS_B',
15806: p_sla_source_chr_id => l_chr_id,
15807: p_sla_source_kle_id => l_source_cle_id,
15808: --Bug# 6373605--SLA populate sources
15809: x_fa_trx_date => l_fa_adj_date);

Line 16259: ,okl_txl_assets_b txlb

16255: IS
16256: SELECT cleb.dnz_chr_id,
16257: tasb.date_trans_occurred
16258: FROM okl_trx_assets tasb
16259: ,okl_txl_assets_b txlb
16260: ,okc_k_lines_b cleb
16261: ,okc_line_styles_b lseb
16262: WHERE txlb.tas_id = tasb.id
16263: AND cleb.id = txlb.kle_id

Line 16594: OKL_TXL_ASSETS_B TAL

16590: CURSOR l_tal_csr(p_fixedasst_line IN NUMBER) IS
16591: SELECT tal.id tal_id,
16592: tas.id tas_id
16593: FROM OKL_TRX_ASSETS TAS,
16594: OKL_TXL_ASSETS_B TAL
16595: WHERE tas.id = tal.tas_id
16596: AND tas.tsu_code = 'ENTERED'
16597: AND tas.tas_type = 'ALI'
16598: AND tal.tal_type = 'ALI'

Line 16602: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;

16598: AND tal.tal_type = 'ALI'
16599: AND tal.kle_id = p_fixedasst_line;
16600:
16601: l_tas_id OKL_TRX_ASSETS.ID%TYPE;
16602: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
16603: l_cle_id OKC_K_LINES_B.ID%TYPE;
16604:
16605: l_tasv_rec okl_trx_assets_pub.thpv_rec_type;
16606: lx_tasv_rec okl_trx_assets_pub.thpv_rec_type;