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_REPORT_GENERATOR_PVT dependencies on OKL_REPORT_TRX_PARAMS

Line 652: ,okl_report_trx_params rtryp

648: ,okl_products pdt
649: ,okl_ae_tmpt_sets_all aes
650: ,okl_st_gen_tmpt_sets_all gts
651: ,okl_reports_b rep
652: ,okl_report_trx_params rtryp
653: ,okl_rep_products_gt pdt_gt
654: -- To fetch Names
655: ,hr_operating_units ou
656: ,xle_entity_profiles le

Line 764: ,okl_report_trx_params rtryp

760: ,okl_products pdt
761: ,okl_ae_tmpt_sets_all aes
762: ,okl_st_gen_tmpt_sets_all gts
763: ,okl_reports_b rep
764: ,okl_report_trx_params rtryp
765: ,okl_rep_products_gt pdt_gt
766: -- To fetch Names
767: ,hr_operating_units ou
768: ,xle_entity_profiles le

Line 891: ,okl_report_trx_params rtryp

887: ,xla_events xe
888: ,xla_event_types_vl xvl
889: -- OLM Reconciliation Report Definitions Table
890: ,okl_reports_b rep
891: ,okl_report_trx_params rtryp
892: ,okl_rep_products_gt pdt_gt
893: -- To fetch Names
894: ,gl_code_combinations_kfv glcc
895: ,hr_operating_units ou

Line 1038: ,okl_report_trx_params rtryp

1034: ,gl_je_headers gh
1035: ,gl_je_lines gl
1036: -- OKL Report Definition Tables
1037: ,okl_reports_b rep
1038: ,okl_report_trx_params rtryp
1039: ,okl_rep_products_gt pdt_gt
1040: -- To fetch Names
1041: ,gl_code_combinations_kfv glcc
1042: ,hr_operating_units ou

Line 1270: ,okl_report_trx_params rtryp

1266: ,okl_trx_types_v try
1267: ,okl_strm_type_v sty
1268: -- OLM Reconciliation Report Entities
1269: ,okl_reports_b rep
1270: ,okl_report_trx_params rtryp
1271: ,okl_rep_products_gt pdt_gt
1272: -- To fetch Names
1273: ,hr_operating_units ou
1274: ,xle_entity_profiles le

Line 1397: ,okl_report_trx_params rtryp

1393: ,xla_events xe
1394: ,xla_event_types_vl xvl
1395: -- OLM Reconciliation Report Entities
1396: ,okl_reports_b rep
1397: ,okl_report_trx_params rtryp
1398: ,okl_rep_products_gt pdt_gt
1399: -- To fetch Names
1400: ,hr_operating_units ou
1401: ,xle_entity_profiles le

Line 1524: ,okl_report_trx_params rtryp

1520: ,xla_ae_headers xh
1521: ,xla_ae_lines xl
1522: -- OLM Reconciliation Report Entities
1523: ,okl_reports_b rep
1524: ,okl_report_trx_params rtryp
1525: ,okl_rep_products_gt pdt_gt
1526: -- To fetch Names
1527: ,hr_operating_units ou
1528: ,xle_entity_profiles le

Line 1680: ,okl_report_trx_params rtryp

1676: ,gl_je_lines gl
1677: ,gl_code_combinations_kfv glcc
1678: -- OLM Reconciliation Report Entities
1679: ,okl_reports_b rep
1680: ,okl_report_trx_params rtryp
1681: ,okl_rep_products_gt pdt_gt
1682: -- To fetch Names
1683: ,hr_operating_units ou
1684: ,xle_entity_profiles le

Line 1921: ,okl_report_trx_params rtryp

1917: ,okl_trx_types_v try
1918: ,okl_strm_type_v sty
1919: -- OLM Reconciliation Report Entities
1920: ,okl_reports_b rep
1921: ,okl_report_trx_params rtryp
1922: ,okl_rep_products_gt pdt_gt
1923: -- To fetch Names
1924: ,hr_operating_units ou
1925: ,gl_ledgers_v ledger

Line 2027: ,okl_report_trx_params rtryp

2023: ,xla_events xe
2024: ,xla_event_types_vl xvl
2025: -- OLM Reconciliation Report Entities
2026: ,okl_reports_b rep
2027: ,okl_report_trx_params rtryp
2028: ,okl_rep_products_gt pdt_gt
2029: -- To fetch Names
2030: ,hr_operating_units ou
2031: ,gl_ledgers_v ledger

Line 2145: ,okl_report_trx_params rtryp

2141: ,ar_adjustments_all radj
2142: ,ar_distributions_all rdist
2143: -- OLM Reconciliation Report Entities
2144: ,okl_reports_b rep
2145: ,okl_report_trx_params rtryp
2146: ,okl_rep_products_gt pdt_gt
2147: -- To fetch Names
2148: ,hr_operating_units ou
2149: ,gl_ledgers_v ledger

Line 2295: ,okl_report_trx_params rtryp

2291: ,ar_adjustments_all radj
2292: ,ar_distributions_all rdist
2293: -- OLM Reconciliation Report Entities
2294: ,okl_reports_b rep
2295: ,okl_report_trx_params rtryp
2296: ,okl_rep_products_gt pdt_gt
2297: -- To fetch Names
2298: ,hr_operating_units ou
2299: ,gl_ledgers_v ledger

Line 2538: ,okl_report_trx_params rtryp

2534: ,okl_trx_types_v try
2535: ,okl_strm_type_v sty
2536: -- OLM Reconciliation Report Entities
2537: ,okl_reports_b rep
2538: ,okl_report_trx_params rtryp
2539: ,okl_rep_products_gt pdt_gt
2540: -- To fetch Names
2541: ,hr_operating_units ou
2542: ,xle_entity_profiles le

Line 2662: ,okl_report_trx_params rtryp

2658: ,xla_events xe
2659: ,xla_event_types_vl xvl
2660: -- OLM Reconciliation Report Entities
2661: ,okl_reports_b rep
2662: ,okl_report_trx_params rtryp
2663: ,okl_rep_products_gt pdt_gt
2664: -- To fetch Names
2665: ,hr_operating_units ou
2666: ,xle_entity_profiles le

Line 2799: ,okl_report_trx_params rtryp

2795: ,xla_ae_headers xh
2796: ,xla_ae_lines xl
2797: -- OLM Reconciliation Report Entities
2798: ,okl_reports_b rep
2799: ,okl_report_trx_params rtryp
2800: ,okl_rep_products_gt pdt_gt
2801: -- To fetch Names
2802: ,hr_operating_units ou
2803: ,xle_entity_profiles le

Line 2964: ,okl_report_trx_params rtryp

2960: ,gl_je_headers gh
2961: ,gl_je_lines gl
2962: -- OLM Reconciliation Report Entities
2963: ,okl_reports_b rep
2964: ,okl_report_trx_params rtryp
2965: ,okl_rep_products_gt pdt_gt
2966: -- To fetch Names
2967: ,hr_operating_units ou
2968: ,xle_entity_profiles le

Line 4787: FROM okl_report_trx_params trep

4783: -- Step 1: Case (a)
4784: NOT EXISTS
4785: (
4786: SELECT 1
4787: FROM okl_report_trx_params trep
4788: WHERE trep.try_id = gt.value8_num -- trx_try_id
4789: AND NVL( trep.sty_id,
4790: gt.value12_num -- Stream Type Id
4791: ) = gt.value12_num -- Stream Type Id

Line 6021: FROM okl_report_trx_params param,

6017: --Cursor to fetch stream type IDs which are not specified in the template
6018: CURSOR C_STREAM_TYPES_NOT_SPECIFIED
6019: IS
6020: SELECT param.STY_ID
6021: FROM okl_report_trx_params param,
6022: okl_trx_types_b trx
6023: WHERE report_id = p_report_id
6024: AND trx.id = param.try_id
6025: AND trx.AEP_CODE = 'ACCRUAL'

Line 6268: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS where report_id = p_report_id)

6264: AND TCN.KHR_ID = TCL.KHR_ID
6265: AND CLE.ID (+) = TCL.KLE_ID
6266: --
6267: AND TCN.SET_OF_BOOKS_ID = p_ledger_id
6268: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS where report_id = p_report_id)
6269: AND TCN.ACCRUAL_ACTIVITY <> 'REVERSAL'
6270: AND OU.ORGANIZATION_ID = TCN.ORG_ID
6271: AND NVL(TCN.SOURCE_TRX_ID,-1) NOT IN (SELECT ID
6272: FROM OKL_TRX_CONTRACTS_ALL RBK_TRX

Line 6339: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS where report_id = p_report_id)

6335: AND TCN.KHR_ID = TCL.KHR_ID
6336: AND CLE.ID (+) = TCL.KLE_ID
6337: --
6338: AND TCN.SET_OF_BOOKS_ID = p_ledger_id
6339: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS where report_id = p_report_id)
6340: AND TCN.ACCRUAL_ACTIVITY = 'REVERSAL'
6341: AND OU.ORGANIZATION_ID = TCN.ORG_ID
6342: AND NVL(TCN.SOURCE_TRX_ID,-1) NOT IN (SELECT ID
6343: FROM OKL_TRX_CONTRACTS_ALL RBK_TRX

Line 6425: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS WHERE report_id = p_report_id)

6421: AND acc_trx.source_trx_type = 'TCN'
6422: AND prod.id = pdt_gt.product_id
6423: AND acc_trx.SET_OF_BOOKS_ID = p_ledger_id
6424: AND rbk_trx.SET_OF_BOOKS_ID = p_ledger_id
6425: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS WHERE report_id = p_report_id)
6426: AND TTY.ID = ACC_TRX.TRY_ID
6427: AND prod.id = p_product_id
6428: AND (ce.Amount - Nvl(pe.Amount,ce.Amount)) <> 0
6429: order by org_id,product_id,khr_id,kle_id,sty_id,line_number;

Line 6433: TYPE sty_id_tbl_type IS TABLE OF OKL_REPORT_TRX_PARAMS.STY_ID%TYPE INDEX BY BINARY_INTEGER;

6429: order by org_id,product_id,khr_id,kle_id,sty_id,line_number;
6430:
6431: TYPE strm_tbl_type IS TABLE OF C_MASTER_STREAMS_SPECIFIED%ROWTYPE INDEX BY BINARY_INTEGER;
6432: TYPE trx_tbl_type IS TABLE OF C_TRANSACTION_LINES%ROWTYPE INDEX BY BINARY_INTEGER;
6433: TYPE sty_id_tbl_type IS TABLE OF OKL_REPORT_TRX_PARAMS.STY_ID%TYPE INDEX BY BINARY_INTEGER;
6434:
6435: l_master_strm_tbl strm_tbl_type;
6436: l_eligible_strm_tbl strm_tbl_type;
6437: l_non_eligible_strm_tbl strm_tbl_type;

Line 7224: ,okl_report_trx_params trep

7220: ,hr_operating_units ou
7221: ,gl_ledgers ledger
7222: ,fnd_application_vl app
7223: ,okc_k_lines_v kle
7224: ,okl_report_trx_params trep
7225: WHERE
7226: -- Restrict the Code Combinations to the one setup on the Report
7227: gl.code_combination_id = cc.ccid AND
7228: -- GL Tables