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.INV_MGD_MVT_FIN_MDTR dependencies on GL_PERIODS

Line 157: GL_PERIODS

153: SELECT end_date
154: INTO
155: l_last_dayofperiod
156: FROM
157: GL_PERIODS
158: WHERE period_name = p_movement_transaction.period_name
159: AND period_set_name = l_period_set_name
160: AND period_type = l_period_type;
161:

Line 1358: GL_PERIODS

1354: SELECT end_date
1355: INTO
1356: l_last_dayofperiod
1357: FROM
1358: GL_PERIODS
1359: WHERE period_name = x_movement_transaction.period_name
1360: AND period_set_name = p_stat_typ_transaction.period_set_name
1361: AND period_type = p_stat_typ_transaction.period_type;
1362:

Line 4524: gl_periods glp

4520: CURSOR c_pname IS
4521: SELECT
4522: glp.period_name
4523: FROM
4524: gl_periods glp
4525: , gl_ledger_le_v gllv
4526: WHERE gllv.period_set_name = glp.period_set_name
4527: AND gllv.legal_entity_id = p_legal_entity_id
4528: AND gllv.ledger_category_code = 'PRIMARY'

Line 4617: GL_PERIODS

4613: CURSOR c_period IS
4614: SELECT
4615: period_name
4616: FROM
4617: GL_PERIODS
4618: WHERE period_set_name = l_stat_typ_transaction.period_set_name
4619: AND l_movement_transaction.transaction_date between
4620: (start_date) and (end_date)
4621: AND start_date >= l_stat_typ_transaction.start_date

Line 4630: GL_PERIODS

4626: CURSOR c_period1 IS
4627: SELECT
4628: period_name
4629: FROM
4630: GL_PERIODS
4631: WHERE period_set_name = l_stat_typ_transaction.period_set_name
4632: AND trunc(l_movement_transaction.transaction_date) between
4633: trunc(start_date) and trunc(end_date)
4634: AND period_type = l_stat_typ_transaction.period_type