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_PROCESS_SALES_TAX_PVT dependencies on OKL_TRX_ASSETS

Line 1286: FROM okl_trx_assets

1282: CURSOR l_taxablelines_csr(cp_kle_id IN NUMBER, cp_request_id IN NUMBER) IS
1283: SELECT id
1284: FROM okl_tax_sources
1285: WHERE trx_id IN (SELECT id
1286: FROM okl_trx_assets
1287: WHERE req_asset_id = cp_request_id)
1288: AND kle_id = cp_kle_id
1289: AND tax_call_type_code = G_UPFRONT_TAX
1290: AND tax_line_status_code = G_ACTIVE_STATUS

Line 1298: FROM okl_trx_assets

1294: CURSOR l_taxablelines_ser_csr(cp_kle_id IN NUMBER, cp_request_id IN NUMBER, cp_sty_id IN NUMBER) IS
1295: SELECT id
1296: FROM okl_tax_sources
1297: WHERE trx_id IN (SELECT id
1298: FROM okl_trx_assets
1299: WHERE req_asset_id = cp_request_id)
1300: AND kle_id = cp_kle_id
1301: AND sty_id = cp_sty_id
1302: AND tax_call_type_code = G_UPFRONT_TAX

Line 1311: FROM okl_trx_assets

1307: CURSOR l_alc_total_tax_ser_csr(cp_request_id IN NUMBER, cp_kle_id IN NUMBER, cp_sty_id IN NUMBER) IS
1308: SELECT SUM(total_tax)
1309: FROM okl_tax_sources
1310: WHERE trx_id IN (SELECT id
1311: FROM okl_trx_assets
1312: WHERE req_asset_id = cp_request_id)
1313: AND kle_id = cp_kle_id
1314: AND sty_id = cp_sty_id
1315: AND tax_call_type_code = G_UPFRONT_TAX

Line 1324: FROM okl_trx_assets

1320: CURSOR l_alc_total_tax_csr(cp_request_id IN NUMBER) IS
1321: SELECT SUM(total_tax)
1322: FROM okl_tax_sources
1323: WHERE trx_id IN (SELECT id
1324: FROM okl_trx_assets
1325: WHERE req_asset_id = cp_request_id)
1326: AND tax_call_type_code = G_UPFRONT_TAX
1327: AND tax_line_status_code = G_ACTIVE_STATUS
1328: AND entity_code = G_ASSETS_ENTITY_CODE

Line 1335: FROM okl_trx_assets

1331: CURSOR l_fetch_stream_types_csr(cp_kle_id IN NUMBER, cp_request_id IN NUMBER) IS
1332: SELECT DISTINCT sty_id
1333: FROM okl_tax_sources
1334: WHERE trx_id IN (SELECT id
1335: FROM okl_trx_assets
1336: WHERE req_asset_id = cp_request_id)
1337: AND kle_id = cp_kle_id
1338: AND tax_call_type_code = G_UPFRONT_TAX
1339: AND tax_line_status_code = G_INACTIVE_STATUS

Line 2598: --p_source_trx_id ---> okl_trx_assets.id

2594: p_source_trx_name IN VARCHAR2,
2595: p_source_table IN VARCHAR2) IS
2596:
2597: ------------- Reverse contract -------------------------
2598: --p_source_trx_id ---> okl_trx_assets.id
2599: --p_source_trx_name ---> 'Reverse'
2600: --p_source_table ---> 'OKL_TRX_CONTRACTS'
2601: --------------------------------------------------
2602: -- Local variables

Line 10942: --p_source_trx_id ---> okl_trx_assets.id

10938: p_request_id IN NUMBER,
10939: p_alc_final_call IN VARCHAR2) IS
10940:
10941: -------------Asset Location Change --------------
10942: --p_source_trx_id ---> okl_trx_assets.id
10943: --p_source_trx_name ---> 'Asset Relocation' (changed from Internal Asset Creation to Asset Relocation)
10944: --p_source_table ---> 'OKL_TRX_ASSETS'
10945: --p_tax_call_type ---> Tax call type
10946: --p_serialized_asset ---> Serialized Asset (Y/N)

Line 10944: --p_source_table ---> 'OKL_TRX_ASSETS'

10940:
10941: -------------Asset Location Change --------------
10942: --p_source_trx_id ---> okl_trx_assets.id
10943: --p_source_trx_name ---> 'Asset Relocation' (changed from Internal Asset Creation to Asset Relocation)
10944: --p_source_table ---> 'OKL_TRX_ASSETS'
10945: --p_tax_call_type ---> Tax call type
10946: --p_serialized_asset ---> Serialized Asset (Y/N)
10947: --p_request_id ---> Id of OKL_trx_Requests
10948: --------------------------------------------------

Line 10954: FROM okl_trx_assets a , okl_trx_types_tl b

10950:
10951: -- validate source trx id
10952: CURSOR l_trxassets_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
10953: SELECT a.try_id, a.date_trans_occurred, a.legal_entity_id
10954: FROM okl_trx_assets a , okl_trx_types_tl b
10955: WHERE a.id = cp_trx_id
10956: AND a.try_id = b.id
10957: AND b.name = cp_trx_type_name
10958: AND language = 'US';

Line 12178: --p_source_trx_id ---> okl_trx_assets.id

12174: p_source_trx_name IN VARCHAR2,
12175: p_source_table IN VARCHAR2) IS
12176:
12177: -------------Split Asset -------------------------
12178: --p_source_trx_id ---> okl_trx_assets.id
12179: --p_source_trx_name ---> 'Split Asset'
12180: --p_source_table ---> 'OKL_TRX_ASSETS'
12181: --------------------------------------------------
12182:

Line 12180: --p_source_table ---> 'OKL_TRX_ASSETS'

12176:
12177: -------------Split Asset -------------------------
12178: --p_source_trx_id ---> okl_trx_assets.id
12179: --p_source_trx_name ---> 'Split Asset'
12180: --p_source_table ---> 'OKL_TRX_ASSETS'
12181: --------------------------------------------------
12182:
12183: -- validate source trx id
12184: CURSOR l_trxassets_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS

Line 12186: FROM okl_trx_assets a, okl_trx_types_tl b

12182:
12183: -- validate source trx id
12184: CURSOR l_trxassets_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
12185: SELECT a.try_id, a.date_trans_occurred
12186: FROM okl_trx_assets a, okl_trx_types_tl b
12187: WHERE a.id = cp_trx_id
12188: AND a.try_id = b.id
12189: AND b.name = cp_trx_type_name
12190: AND language = 'US';

Line 17541: --p_source_trx_id ---> okl_trx_assets.id

17537: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17538: --------------------------------------------------
17539:
17540: -------------- Split Asset ------------------
17541: --p_source_trx_id ---> okl_trx_assets.id
17542: --p_source_trx_name ---> 'Split Asset'
17543: --p_source_table ---> 'OKL_TRX_ASSETS'
17544: --------------------------------------------------
17545:

Line 17543: --p_source_table ---> 'OKL_TRX_ASSETS'

17539:
17540: -------------- Split Asset ------------------
17541: --p_source_trx_id ---> okl_trx_assets.id
17542: --p_source_trx_name ---> 'Split Asset'
17543: --p_source_table ---> 'OKL_TRX_ASSETS'
17544: --------------------------------------------------
17545:
17546: -------------- Reverse ------------------
17547: --p_source_trx_id ---> okl_trx_assets.id

Line 17547: --p_source_trx_id ---> okl_trx_assets.id

17543: --p_source_table ---> 'OKL_TRX_ASSETS'
17544: --------------------------------------------------
17545:
17546: -------------- Reverse ------------------
17547: --p_source_trx_id ---> okl_trx_assets.id
17548: --p_source_trx_name ---> 'Reverse'
17549: --p_source_table ---> 'OKL_TRX_ASSETS'
17550: --------------------------------------------------
17551:

Line 17549: --p_source_table ---> 'OKL_TRX_ASSETS'

17545:
17546: -------------- Reverse ------------------
17547: --p_source_trx_id ---> okl_trx_assets.id
17548: --p_source_trx_name ---> 'Reverse'
17549: --p_source_table ---> 'OKL_TRX_ASSETS'
17550: --------------------------------------------------
17551:
17552: ---- Termination/Repurchase Quote Creation -------
17553: --p_source_trx_id ---> okl_trx_quotes_b.id

Line 17580: CURSOR get_ast_reloc_khr(p_trx_id okl_trx_assets.ID%TYPE) IS

17576: AND trx.id = cp_trx_id
17577: AND trx.request_type_code = 'TAX_SCHEDULES';
17578:
17579: -- ER#9327076
17580: CURSOR get_ast_reloc_khr(p_trx_id okl_trx_assets.ID%TYPE) IS
17581: SELECT cle.dnz_chr_id
17582: FROM okl_trx_assets trx,
17583: okl_txl_itm_insts inst,
17584: okc_k_lines_b cle

Line 17582: FROM okl_trx_assets trx,

17578:
17579: -- ER#9327076
17580: CURSOR get_ast_reloc_khr(p_trx_id okl_trx_assets.ID%TYPE) IS
17581: SELECT cle.dnz_chr_id
17582: FROM okl_trx_assets trx,
17583: okl_txl_itm_insts inst,
17584: okc_k_lines_b cle
17585: WHERE trx.tas_type = 'ALG'
17586: AND inst.tas_id = trx.ID