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

Line 159: gl_ledgers_public_v glp --,

155: IS
156: SELECT s.application_column_name segment_col_name
157: FROM fnd_id_flex_segments s,
158: fnd_segment_attribute_values sav,
159: gl_ledgers_public_v glp --,
160: WHERE s.application_id = 101 -- GL Application ID
161: AND s.id_flex_code = 'GL#'
162: AND s.id_flex_num = glp.chart_of_accounts_id --COA ID
163: AND s.enabled_flag = 'Y'

Line 223: ||' ,gl_ledgers_public_v gl'

219: ||')'
220: ||' SELECT cc.code_combination_id'
221: ||' ,' || l_segment || ' ' -- segment3
222: ||' FROM gl_code_combinations cc'
223: ||' ,gl_ledgers_public_v gl'
224: ||' WHERE cc.chart_of_accounts_id = gl.chart_of_accounts_id'
225: ||' AND cc.enabled_flag = ' || '''' || 'Y' || ''''
226: ||' AND gl.ledger_id = ' || p_ledger_id
227: ||' AND EXISTS'

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

Line 3466: FROM gl_ledgers gl

3462: )
3463: IS
3464: SELECT gl.period_set_name period_set_name
3465: ,per.period_type period_type
3466: FROM gl_ledgers gl
3467: ,gl_periods per
3468: WHERE gl.ledger_id = p_ledger_id
3469: AND per.period_set_name = gl.period_set_name
3470: AND per.period_name = p_period_from;

Line 3657: ,gl_ledgers ledger

3653: ,gl_je_headers gh
3654: ,gl_code_combinations_kfv glcc
3655: -- Code Combination GT Table
3656: ,okl_code_cmbns_gt cc
3657: ,gl_ledgers ledger
3658: ,fnd_application_vl app
3659: WHERE
3660: -- Restrict the Code Combinations to the one setup on the Report
3661: gl.code_combination_id = cc.ccid AND

Line 3824: ,gl_ledgers ledger

3820: ,xla_ae_headers xh
3821: ,xla_events xe
3822: ,xla_event_types_vl xvl
3823: ,xla_transaction_entities xte
3824: ,gl_ledgers ledger
3825: ,fnd_application_vl app
3826: WHERE
3827: -- Restrict the Code Combinations to the one setup on the Report
3828: gl.code_combination_id = cc.ccid AND

Line 4028: ,gl_ledgers ledger

4024: ,okl_ae_tmpt_sets_all aes
4025: ,okl_st_gen_tmpt_sets_all gts
4026: -- To fetch Names
4027: ,hr_operating_units ou
4028: ,gl_ledgers ledger
4029: ,fnd_application_vl app
4030: WHERE
4031: -- Restrict the Code Combinations to the one setup on the Report
4032: gl.code_combination_id = cc.ccid AND

Line 4251: ,gl_ledgers ledger

4247: ,okl_trx_types_v try
4248: ,okl_strm_type_v sty
4249: -- To fetch Names
4250: ,hr_operating_units ou
4251: ,gl_ledgers ledger
4252: ,fnd_application_vl app
4253: WHERE
4254: -- Restrict the Code Combinations to the one setup on the Report
4255: gl.code_combination_id = cc.ccid AND

Line 4474: ,gl_ledgers ledger

4470: ,okl_trx_types_v try
4471: ,okl_strm_type_v sty
4472: -- To fetch Names
4473: ,hr_operating_units ou
4474: ,gl_ledgers ledger
4475: ,fnd_application_vl app
4476: WHERE
4477: -- Restrict the Code Combinations to the one setup on the Report
4478: gl.code_combination_id = cc.ccid AND

Line 4696: ,gl_ledgers ledger

4692: ,okl_trx_types_v try
4693: ,okl_strm_type_v sty
4694: -- To fetch Names
4695: ,hr_operating_units ou
4696: ,gl_ledgers ledger
4697: ,fnd_application_vl app
4698: WHERE
4699: -- Restrict the Code Combinations to the one setup on the Report
4700: gl.code_combination_id = cc.ccid AND

Line 4976: ,gl_ledgers ledger

4972: ,xla_ae_headers xh
4973: ,xla_events xe
4974: ,xla_event_types_vl xvl
4975: ,xla_transaction_entities xte
4976: ,gl_ledgers ledger
4977: ,fnd_application_vl app
4978: WHERE
4979: -- Restrict the Code Combinations to the one setup on the Report
4980: gl.code_combination_id = cc.ccid AND

Line 5155: ,gl_ledgers led

5151: - begin_balance_cr ) opening_bal_trx_curr
5152: ,( begin_balance_dr_beq
5153: - begin_balance_cr_beq ) opening_bal_led_curr
5154: FROM gl_balances bal
5155: ,gl_ledgers led
5156: ,okl_code_cmbns_gt cc_gt
5157: WHERE led.ledger_id = p_ledger_id
5158: AND bal.ledger_id = led.ledger_id
5159: -- opening Balance as on Period Start

Line 5187: ,gl_ledgers led

5183: ,bal.period_name period_name
5184: ,( begin_balance_dr
5185: - begin_balance_cr ) opening_bal_led_curr
5186: FROM gl_balances bal
5187: ,gl_ledgers led
5188: ,okl_code_cmbns_gt cc_gt
5189: WHERE led.ledger_id = p_ledger_id
5190: AND bal.ledger_id = led.ledger_id
5191: -- opening Balance as on Period Start

Line 5242: FROM gl_ledgers

5238: WHERE value1_text = 'GL_OPENING_BALANCE' --value1_text
5239: AND value11_text IN
5240: (
5241: SELECT currency_code
5242: FROM gl_ledgers
5243: WHERE ledger_id = p_ledger_id
5244: );
5245:
5246: --Bug:7535993 by nikshah

Line 5263: from gl_ledgers

5259: )
5260: SELECT -- String Formatted Columns
5261: 'GL_OPENING_BALANCE' --value1_text
5262: ,(select currency_code
5263: from gl_ledgers
5264: where ledger_id = p_ledger_id) --value11_text
5265: ,p_period_from --value12_text
5266: ,cgt.account_number --value13_text -- Stores the Segment Number
5267: ,0 --value1_num

Line 5326: ,gl_ledgers led

5322: period_net_cr period_activity_trx_curr
5323: ,period_net_dr_beq -
5324: period_net_cr_beq period_activity_led_curr
5325: FROM gl_balances bal
5326: ,gl_ledgers led
5327: ,okl_code_cmbns_gt cc_gt
5328: ,gl_period_statuses gps
5329: WHERE led.ledger_id = p_ledger_id
5330: AND bal.ledger_id = led.ledger_id

Line 5374: ,gl_ledgers led

5370: ,bal.period_name period_name
5371: ,period_net_dr -
5372: period_net_cr period_activity_led_curr
5373: FROM gl_balances bal
5374: ,gl_ledgers led
5375: ,okl_code_cmbns_gt cc_gt
5376: ,gl_period_statuses gps
5377: WHERE led.ledger_id = p_ledger_id
5378: AND gps.application_id = 101

Line 5445: FROM gl_ledgers

5441: WHERE value1_text = 'GL_PERIOD_ACTIVITY' --value1_text
5442: AND value11_text IN
5443: (
5444: SELECT currency_code
5445: FROM gl_ledgers
5446: WHERE ledger_id = p_ledger_id
5447: );
5448:
5449: --Bug:7535993 by nikshah

Line 5466: from gl_ledgers

5462: )
5463: SELECT -- String Formatted Columns
5464: 'GL_PERIOD_ACTIVITY' --value1_text
5465: ,(select currency_code
5466: from gl_ledgers
5467: where ledger_id = p_ledger_id) --value11_text
5468: ,null --value12_text
5469: ,cgt.account_number --value13_text -- Stores the Segment Number
5470: -- Number Formatted Columns

Line 5547: ,gl_ledgers led

5543: + begin_balance_cr_beq
5544: )
5545: ) closing_bal_led_curr
5546: FROM gl_balances bal
5547: ,gl_ledgers led
5548: ,okl_code_cmbns_gt cc_gt
5549: WHERE led.ledger_id = p_ledger_id
5550: AND bal.ledger_id = led.ledger_id
5551: -- Closing Balance as on Period End

Line 5586: ,gl_ledgers led

5582: + begin_balance_cr
5583: )
5584: ) closing_bal_led_curr
5585: FROM gl_balances bal
5586: ,gl_ledgers led
5587: ,okl_code_cmbns_gt cc_gt
5588: WHERE led.ledger_id = p_ledger_id
5589: AND bal.ledger_id = led.ledger_id
5590: -- Closing Balance as on Period End

Line 5641: FROM gl_ledgers

5637: WHERE value1_text = 'GL_CLOSING_BALANCE' --value1_text
5638: AND value11_text IN
5639: (
5640: SELECT currency_code
5641: FROM gl_ledgers
5642: WHERE ledger_id = p_ledger_id
5643: );
5644:
5645: --Bug:7535993 by nikshah

Line 5662: from gl_ledgers

5658: )
5659: SELECT -- String Formatted Columns
5660: 'GL_CLOSING_BALANCE' --value1_text
5661: ,(select currency_code
5662: from gl_ledgers
5663: where ledger_id = p_ledger_id) --value11_text
5664: ,p_period_to --value12_text
5665: ,cgt.account_number --value13_text -- Stores the Segment Number
5666: -- Number Formatted Columns

Line 6059: FROM gl_ledgers gl

6055: STY.ID STY_ID,
6056: (SELECT per.period_name
6057: FROM gl_periods per
6058: WHERE per.period_set_name = (SELECT gl.period_set_name
6059: FROM gl_ledgers gl
6060: WHERE ledger_id = p_ledger_id)
6061: AND per.START_DATE <= STE.STREAM_ELEMENT_DATE
6062: AND per.end_date >= STE.STREAM_ELEMENT_DATE
6063: AND per.adjustment_period_flag = 'N'

Line 6065: FROM gl_ledgers gl

6061: AND per.START_DATE <= STE.STREAM_ELEMENT_DATE
6062: AND per.end_date >= STE.STREAM_ELEMENT_DATE
6063: AND per.adjustment_period_flag = 'N'
6064: AND period_type = (SELECT gl.accounted_period_type
6065: FROM gl_ledgers gl
6066: WHERE ledger_id = p_ledger_id)
6067: ) STREAM_PERIOD
6068: FROM OKL_STRM_TYPE_V STY,
6069: okl_streams_rep_v STM,

Line 6147: FROM gl_ledgers gl

6143: STY.ID STY_ID,
6144: (SELECT per.period_name
6145: FROM gl_periods per
6146: WHERE per.period_set_name = (SELECT gl.period_set_name
6147: FROM gl_ledgers gl
6148: WHERE ledger_id = p_ledger_id)
6149: AND per.START_DATE <= STE.STREAM_ELEMENT_DATE
6150: AND per.end_date >= STE.STREAM_ELEMENT_DATE
6151: AND per.adjustment_period_flag = 'N'

Line 6153: FROM gl_ledgers gl

6149: AND per.START_DATE <= STE.STREAM_ELEMENT_DATE
6150: AND per.end_date >= STE.STREAM_ELEMENT_DATE
6151: AND per.adjustment_period_flag = 'N'
6152: AND period_type = (SELECT gl.accounted_period_type
6153: FROM gl_ledgers gl
6154: WHERE ledger_id = p_ledger_id)
6155: ) STREAM_PERIOD
6156: FROM OKL_STRM_TYPE_V STY,
6157: okl_streams_rep_v STM,

Line 6244: FROM gl_ledgers gl

6240: TTY.NAME TRANSACTION_TYPE,
6241: (SELECT per.period_name
6242: FROM gl_periods per
6243: WHERE per.period_set_name = (SELECT gl.period_set_name
6244: FROM gl_ledgers gl
6245: WHERE ledger_id = p_ledger_id)
6246: AND per.START_DATE <= TCN.TRANSACTION_DATE
6247: AND per.end_date >= TCN.TRANSACTION_DATE
6248: AND per.adjustment_period_flag = 'N'

Line 6250: FROM gl_ledgers gl

6246: AND per.START_DATE <= TCN.TRANSACTION_DATE
6247: AND per.end_date >= TCN.TRANSACTION_DATE
6248: AND per.adjustment_period_flag = 'N'
6249: AND period_type = (SELECT gl.accounted_period_type
6250: FROM gl_ledgers gl
6251: WHERE ledger_id = p_ledger_id)
6252: ) TRANSACTION_PERIOD,
6253: NULL REVERSAL_PERIOD
6254: FROM OKL_TRX_CONTRACTS_ALL TCN,

Line 6304: FROM gl_ledgers gl

6300: TTY.NAME TRANSACTION_TYPE,
6301: (SELECT per.period_name
6302: FROM gl_periods per
6303: WHERE per.period_set_name = (SELECT gl.period_set_name
6304: FROM gl_ledgers gl
6305: WHERE ledger_id = p_ledger_id)
6306: AND per.START_DATE <= TCN.TRANSACTION_DATE
6307: AND per.end_date >= TCN.TRANSACTION_DATE
6308: AND per.adjustment_period_flag = 'N'

Line 6310: FROM gl_ledgers gl

6306: AND per.START_DATE <= TCN.TRANSACTION_DATE
6307: AND per.end_date >= TCN.TRANSACTION_DATE
6308: AND per.adjustment_period_flag = 'N'
6309: AND period_type = (SELECT gl.accounted_period_type
6310: FROM gl_ledgers gl
6311: WHERE ledger_id = p_ledger_id)
6312: ) TRANSACTION_PERIOD,
6313: (SELECT per.period_name
6314: FROM gl_periods per

Line 6316: FROM gl_ledgers gl

6312: ) TRANSACTION_PERIOD,
6313: (SELECT per.period_name
6314: FROM gl_periods per
6315: WHERE per.period_set_name = (SELECT gl.period_set_name
6316: FROM gl_ledgers gl
6317: WHERE ledger_id = p_ledger_id)
6318: AND per.START_DATE <= TCN.TRANSACTION_REVERSAL_DATE
6319: AND per.end_date >= TCN.TRANSACTION_REVERSAL_DATE
6320: AND per.adjustment_period_flag = 'N'

Line 6322: FROM gl_ledgers gl

6318: AND per.START_DATE <= TCN.TRANSACTION_REVERSAL_DATE
6319: AND per.end_date >= TCN.TRANSACTION_REVERSAL_DATE
6320: AND per.adjustment_period_flag = 'N'
6321: AND period_type = (SELECT gl.accounted_period_type
6322: FROM gl_ledgers gl
6323: WHERE ledger_id = p_ledger_id)
6324: ) REVERSAL_PERIOD
6325: FROM OKL_TRX_CONTRACTS_ALL TCN,
6326: OKL_TXL_CNTRCT_LNS_ALL TCL,

Line 7221: ,gl_ledgers ledger

7217: ,okl_ae_tmpt_sets_all aes
7218: ,okl_st_gen_tmpt_sets_all gts
7219: -- To fetch Names
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

Line 7366: FROM GL_LEDGERS

7362:
7363: --Cursor to fetch representation type of ledger
7364: CURSOR C_GET_LEGER_REPRENSENTATION(p_ledger_id NUMBER) IS
7365: SELECT NVL(LEDGER_CATEGORY_CODE,'PRIMARY') LEDGER_CATEGORY_CODE
7366: FROM GL_LEDGERS
7367: WHERE LEDGER_ID = p_ledger_id;
7368:
7369: l_init_msg_list VARCHAR2(1);
7370: l_msg_count NUMBER;