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 10907: --p_source_trx_id ---> okl_trx_assets.id

10903: p_request_id IN NUMBER,
10904: p_alc_final_call IN VARCHAR2) IS
10905:
10906: -------------Asset Location Change --------------
10907: --p_source_trx_id ---> okl_trx_assets.id
10908: --p_source_trx_name ---> 'Asset Relocation' (changed from Internal Asset Creation to Asset Relocation)
10909: --p_source_table ---> 'OKL_TRX_ASSETS'
10910: --p_tax_call_type ---> Tax call type
10911: --p_serialized_asset ---> Serialized Asset (Y/N)

Line 10909: --p_source_table ---> 'OKL_TRX_ASSETS'

10905:
10906: -------------Asset Location Change --------------
10907: --p_source_trx_id ---> okl_trx_assets.id
10908: --p_source_trx_name ---> 'Asset Relocation' (changed from Internal Asset Creation to Asset Relocation)
10909: --p_source_table ---> 'OKL_TRX_ASSETS'
10910: --p_tax_call_type ---> Tax call type
10911: --p_serialized_asset ---> Serialized Asset (Y/N)
10912: --p_request_id ---> Id of OKL_trx_Requests
10913: --------------------------------------------------

Line 10919: FROM okl_trx_assets a , okl_trx_types_tl b

10915:
10916: -- validate source trx id
10917: CURSOR l_trxassets_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
10918: SELECT a.try_id, a.date_trans_occurred, a.legal_entity_id
10919: FROM okl_trx_assets a , okl_trx_types_tl b
10920: WHERE a.id = cp_trx_id
10921: AND a.try_id = b.id
10922: AND b.name = cp_trx_type_name
10923: AND language = 'US';

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

12139: p_source_trx_name IN VARCHAR2,
12140: p_source_table IN VARCHAR2) IS
12141:
12142: -------------Split Asset -------------------------
12143: --p_source_trx_id ---> okl_trx_assets.id
12144: --p_source_trx_name ---> 'Split Asset'
12145: --p_source_table ---> 'OKL_TRX_ASSETS'
12146: --------------------------------------------------
12147:

Line 12145: --p_source_table ---> 'OKL_TRX_ASSETS'

12141:
12142: -------------Split Asset -------------------------
12143: --p_source_trx_id ---> okl_trx_assets.id
12144: --p_source_trx_name ---> 'Split Asset'
12145: --p_source_table ---> 'OKL_TRX_ASSETS'
12146: --------------------------------------------------
12147:
12148: -- validate source trx id
12149: CURSOR l_trxassets_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS

Line 12151: FROM okl_trx_assets a, okl_trx_types_tl b

12147:
12148: -- validate source trx id
12149: CURSOR l_trxassets_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
12150: SELECT a.try_id, a.date_trans_occurred
12151: FROM okl_trx_assets a, okl_trx_types_tl b
12152: WHERE a.id = cp_trx_id
12153: AND a.try_id = b.id
12154: AND b.name = cp_trx_type_name
12155: AND language = 'US';

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

17465: --p_tax_call_type ---> 'ESTIMATED'/'ACTUAL' call type
17466: --------------------------------------------------
17467:
17468: -------------- Split Asset ------------------
17469: --p_source_trx_id ---> okl_trx_assets.id
17470: --p_source_trx_name ---> 'Split Asset'
17471: --p_source_table ---> 'OKL_TRX_ASSETS'
17472: --------------------------------------------------
17473:

Line 17471: --p_source_table ---> 'OKL_TRX_ASSETS'

17467:
17468: -------------- Split Asset ------------------
17469: --p_source_trx_id ---> okl_trx_assets.id
17470: --p_source_trx_name ---> 'Split Asset'
17471: --p_source_table ---> 'OKL_TRX_ASSETS'
17472: --------------------------------------------------
17473:
17474: -------------- Reverse ------------------
17475: --p_source_trx_id ---> okl_trx_assets.id

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

17471: --p_source_table ---> 'OKL_TRX_ASSETS'
17472: --------------------------------------------------
17473:
17474: -------------- Reverse ------------------
17475: --p_source_trx_id ---> okl_trx_assets.id
17476: --p_source_trx_name ---> 'Reverse'
17477: --p_source_table ---> 'OKL_TRX_ASSETS'
17478: --------------------------------------------------
17479:

Line 17477: --p_source_table ---> 'OKL_TRX_ASSETS'

17473:
17474: -------------- Reverse ------------------
17475: --p_source_trx_id ---> okl_trx_assets.id
17476: --p_source_trx_name ---> 'Reverse'
17477: --p_source_table ---> 'OKL_TRX_ASSETS'
17478: --------------------------------------------------
17479:
17480: ---- Termination/Repurchase Quote Creation -------
17481: --p_source_trx_id ---> okl_trx_quotes_b.id