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_TYPES_TL

Line 2648: FROM okl_trx_contracts a, okl_trx_types_tl b

2644: AND tax_line_status_code = G_ACTIVE_STATUS;
2645:
2646: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
2647: SELECT a.try_id, a.khr_id, a.legal_entity_id, a.date_transaction_occurred
2648: FROM okl_trx_contracts a, okl_trx_types_tl b
2649: WHERE a.id = cp_trx_id
2650: AND a.try_id = b.id
2651: AND b.name = cp_trx_type_name
2652: AND language = 'US';

Line 8148: FROM okl_trx_requests a, okl_trx_types_tl b

8144:
8145: -- get the tax schedule request details
8146: CURSOR l_trxrequests_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
8147: SELECT a.dnz_khr_id, a.start_date, a.end_date, a.try_id, a.legal_entity_id, a.org_id
8148: FROM okl_trx_requests a, okl_trx_types_tl b
8149: WHERE a.id = cp_trx_id
8150: AND a.try_id = b.id
8151: AND b.name = cp_trx_type_name
8152: AND language = 'US';

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 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 13167: FROM okl_trx_contracts a , okl_trx_types_tl b

13163:
13164: -- validate source trx id (Booking)
13165: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13166: SELECT a.try_id, a.khr_id, a.legal_entity_id
13167: FROM okl_trx_contracts a , okl_trx_types_tl b
13168: WHERE a.id = cp_trx_id
13169: AND a.try_id = b.id
13170: AND b.name = cp_trx_type_name
13171: AND language = 'US';

Line 13178: FROM okl_trx_contracts a , okl_trx_types_tl b

13174: -- okl_trx_contracts.khr_id has original contract id
13175: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13176: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13177: SELECT a.khr_id_new, a.legal_entity_id
13178: FROM okl_trx_contracts a , okl_trx_types_tl b
13179: WHERE a.id = cp_trx_id
13180: AND a.try_id = b.id
13181: AND b.name = cp_trx_type_name
13182: AND language = 'US';

Line 15006: FROM okl_trx_contracts a , okl_trx_types_tl b

15002: -- okl_trx_contracts.khr_id has original contract id
15003: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15004: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15005: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15006: FROM okl_trx_contracts a , okl_trx_types_tl b
15007: WHERE a.id = cp_trx_id
15008: AND a.try_id = b.id
15009: AND b.name = cp_trx_type_name
15010: AND language = 'US';

Line 15682: FROM okl_trx_types_tl

15678:
15679: -- Get the transaction type id
15680: CURSOR l_trxtypes_csr IS
15681: SELECT id
15682: FROM okl_trx_types_tl
15683: WHERE name = 'Sales Quote'
15684: AND language = 'US';
15685:
15686: -- Get Currency code and cust a/c for lease opportunity

Line 20753: FROM okl_trx_contracts a , okl_trx_types_tl b

20749: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20750:
20751: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20752: SELECT '1'
20753: FROM okl_trx_contracts a , okl_trx_types_tl b
20754: WHERE a.id = cp_trx_id
20755: AND a.try_id = b.id
20756: AND b.name = cp_trx_type_name
20757: AND language = 'US';

Line 20761: FROM okl_trx_contracts_all a , okl_trx_types_tl b

20757: AND language = 'US';
20758:
20759: CURSOR l_trxcontracts_base_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20760: SELECT '1'
20761: FROM okl_trx_contracts_all a , okl_trx_types_tl b
20762: WHERE a.id = cp_trx_id
20763: AND a.try_id = b.id
20764: AND b.name = cp_trx_type_name
20765: AND language = 'US';