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 8179: FROM okl_trx_requests a, okl_trx_types_tl b

8175:
8176: -- get the tax schedule request details
8177: CURSOR l_trxrequests_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
8178: SELECT a.dnz_khr_id, a.start_date, a.end_date, a.try_id, a.legal_entity_id, a.org_id
8179: FROM okl_trx_requests a, okl_trx_types_tl b
8180: WHERE a.id = cp_trx_id
8181: AND a.try_id = b.id
8182: AND b.name = cp_trx_type_name
8183: AND language = 'US';

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

13198:
13199: -- validate source trx id (Booking)
13200: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13201: SELECT a.try_id, a.khr_id, a.legal_entity_id
13202: FROM okl_trx_contracts a , okl_trx_types_tl b
13203: WHERE a.id = cp_trx_id
13204: AND a.try_id = b.id
13205: AND b.name = cp_trx_type_name
13206: AND language = 'US';

Line 13213: FROM okl_trx_contracts a , okl_trx_types_tl b

13209: -- okl_trx_contracts.khr_id has original contract id
13210: -- okl_trx_contracts.khr_id_new has rebook copy contract id
13211: CURSOR l_trxcontracts_rbk_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
13212: SELECT a.khr_id_new, a.legal_entity_id
13213: FROM okl_trx_contracts a , okl_trx_types_tl b
13214: WHERE a.id = cp_trx_id
13215: AND a.try_id = b.id
13216: AND b.name = cp_trx_type_name
13217: AND language = 'US';

Line 15077: FROM okl_trx_contracts a , okl_trx_types_tl b

15073: -- okl_trx_contracts.khr_id has original contract id
15074: -- okl_trx_contracts.khr_id_new has rebook copy contract id
15075: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
15076: SELECT a.try_id, a.khr_id, a.khr_id_new, a.date_transaction_occurred
15077: FROM okl_trx_contracts a , okl_trx_types_tl b
15078: WHERE a.id = cp_trx_id
15079: AND a.try_id = b.id
15080: AND b.name = cp_trx_type_name
15081: AND language = 'US';

Line 15754: FROM okl_trx_types_tl

15750:
15751: -- Get the transaction type id
15752: CURSOR l_trxtypes_csr IS
15753: SELECT id
15754: FROM okl_trx_types_tl
15755: WHERE name = 'Sales Quote'
15756: AND language = 'US';
15757:
15758: -- Get Currency code and cust a/c for lease opportunity

Line 20941: FROM okl_trx_contracts a , okl_trx_types_tl b

20937: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20938:
20939: CURSOR l_trxcontracts_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20940: SELECT '1'
20941: FROM okl_trx_contracts a , okl_trx_types_tl b
20942: WHERE a.id = cp_trx_id
20943: AND a.try_id = b.id
20944: AND b.name = cp_trx_type_name
20945: AND language = 'US';

Line 20949: FROM okl_trx_contracts_all a , okl_trx_types_tl b

20945: AND language = 'US';
20946:
20947: CURSOR l_trxcontracts_base_csr(cp_trx_id IN NUMBER, cp_trx_type_name IN VARCHAR2) IS
20948: SELECT '1'
20949: FROM okl_trx_contracts_all a , okl_trx_types_tl b
20950: WHERE a.id = cp_trx_id
20951: AND a.try_id = b.id
20952: AND b.name = cp_trx_type_name
20953: AND language = 'US';