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 GL_LEDGERS_V

Line 657: ,gl_ledgers_v ledger

653: ,okl_rep_products_gt pdt_gt
654: -- To fetch Names
655: ,hr_operating_units ou
656: ,xle_entity_profiles le
657: ,gl_ledgers_v ledger
658: WHERE trx.id = txl.tcn_id
659: AND trx.try_id = try.id
660: AND try.accounting_event_class_code IS NOT NULL
661: AND txl.sty_id = sty.id -- May be we dont need outer join here

Line 769: ,gl_ledgers_v ledger

765: ,okl_rep_products_gt pdt_gt
766: -- To fetch Names
767: ,hr_operating_units ou
768: ,xle_entity_profiles le
769: ,gl_ledgers_v ledger
770: -- XLA Entities
771: ,xla_events xe
772: ,xla_event_types_vl xvl
773: WHERE trx.id = txl.tcn_id

Line 897: ,gl_ledgers_v ledger

893: -- To fetch Names
894: ,gl_code_combinations_kfv glcc
895: ,hr_operating_units ou
896: ,xle_entity_profiles le
897: ,gl_ledgers_v ledger
898: WHERE trx.id = txl.tcn_id
899: AND trx.try_id = try.id
900: AND try.accounting_event_class_code IS NOT NULL
901: AND txl.sty_id = sty.id -- May be we dont need outer join here

Line 1044: ,gl_ledgers_v ledger

1040: -- To fetch Names
1041: ,gl_code_combinations_kfv glcc
1042: ,hr_operating_units ou
1043: ,xle_entity_profiles le
1044: ,gl_ledgers_v ledger
1045: WHERE trx.id = txl.tcn_id
1046: AND trx.try_id = try.id
1047: AND try.accounting_event_class_code IS NOT NULL
1048: AND txl.sty_id = sty.id -- May be we dont need outer join here

Line 1275: ,gl_ledgers_v ledger

1271: ,okl_rep_products_gt pdt_gt
1272: -- To fetch Names
1273: ,hr_operating_units ou
1274: ,xle_entity_profiles le
1275: ,gl_ledgers_v ledger
1276: WHERE -- OKL to AR Application Predicates
1277: txd.til_id_details = til.id -- Trx. Detail to Trx. Line
1278: AND til.tai_id = tai.id -- Trx. Line to Trx. Header
1279: AND txd.khr_id = chr.id -- Trx. Header to Contract

Line 1402: ,gl_ledgers_v ledger

1398: ,okl_rep_products_gt pdt_gt
1399: -- To fetch Names
1400: ,hr_operating_units ou
1401: ,xle_entity_profiles le
1402: ,gl_ledgers_v ledger
1403: WHERE -- OKL to AR Application Predicates
1404: txd.til_id_details = til.id -- Trx. Detail to Trx. Line
1405: AND til.tai_id = tai.id -- Trx. Line to Trx. Header
1406: AND txd.khr_id = chr.id -- Trx. Header to Contract

Line 1529: ,gl_ledgers_v ledger

1525: ,okl_rep_products_gt pdt_gt
1526: -- To fetch Names
1527: ,hr_operating_units ou
1528: ,xle_entity_profiles le
1529: ,gl_ledgers_v ledger
1530: WHERE -- OKL to AR Application Predicates
1531: txd.til_id_details = til.id -- Trx. Detail to Trx. Line
1532: AND til.tai_id = tai.id -- Trx. Line to Trx. Header
1533: AND txd.khr_id = chr.id -- Trx. Header to Contract

Line 1685: ,gl_ledgers_v ledger

1681: ,okl_rep_products_gt pdt_gt
1682: -- To fetch Names
1683: ,hr_operating_units ou
1684: ,xle_entity_profiles le
1685: ,gl_ledgers_v ledger
1686: WHERE -- OKL to AR Application Predicates
1687: txd.til_id_details = til.id -- Trx. Detail to Trx. Line
1688: AND til.tai_id = tai.id -- Trx. Line to Trx. Header
1689: AND txd.khr_id = chr.id -- Trx. Header to Contract

Line 1925: ,gl_ledgers_v ledger

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
1926: WHERE -- OKL - AR Adjustment Application Predicates
1927: adj.id = ajl.adj_id
1928: AND ajl.til_id = til.id
1929: -- Important Predicate

Line 2031: ,gl_ledgers_v ledger

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
2032: WHERE -- OKL - AR Adjustment Application Predicates
2033: adj.id = ajl.adj_id
2034: AND ajl.til_id = til.id
2035: AND til.tai_id = tai.id

Line 2149: ,gl_ledgers_v ledger

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
2150: -- XLA Tables
2151: ,xla_events xe
2152: ,xla_event_types_vl xvl
2153: ,xla_distribution_links xd

Line 2299: ,gl_ledgers_v ledger

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
2300: -- XLA Tables
2301: ,xla_events xe
2302: ,xla_event_types_vl xvl
2303: ,xla_distribution_links xd

Line 2543: ,gl_ledgers_v ledger

2539: ,okl_rep_products_gt pdt_gt
2540: -- To fetch Names
2541: ,hr_operating_units ou
2542: ,xle_entity_profiles le
2543: ,gl_ledgers_v ledger
2544: WHERE
2545: -- OKL to AP Application Predicates
2546: tpl.tap_id = tap.id
2547: -- Restrict to only transactions which are not yet moved to AP

Line 2667: ,gl_ledgers_v ledger

2663: ,okl_rep_products_gt pdt_gt
2664: -- To fetch Names
2665: ,hr_operating_units ou
2666: ,xle_entity_profiles le
2667: ,gl_ledgers_v ledger
2668: WHERE
2669: -- OKL to AP Application Predicates
2670: tpl.tap_id = tap.id
2671: AND tpl.khr_id = khr.id

Line 2804: ,gl_ledgers_v ledger

2800: ,okl_rep_products_gt pdt_gt
2801: -- To fetch Names
2802: ,hr_operating_units ou
2803: ,xle_entity_profiles le
2804: ,gl_ledgers_v ledger
2805: WHERE
2806: -- OKL to AP Application Predicates
2807: tpl.tap_id = tap.id
2808: AND tpl.khr_id = khr.id

Line 2969: ,gl_ledgers_v ledger

2965: ,okl_rep_products_gt pdt_gt
2966: -- To fetch Names
2967: ,hr_operating_units ou
2968: ,xle_entity_profiles le
2969: ,gl_ledgers_v ledger
2970: WHERE
2971: -- OKL to AP Application Predicates
2972: tpl.tap_id = tap.id
2973: AND tpl.khr_id = khr.id