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 1325: GL_PERIODS

1321: SELECT end_date
1322: INTO
1323: l_last_dayofperiod
1324: FROM
1325: GL_PERIODS
1326: WHERE period_name = x_movement_transaction.period_name
1327: AND period_set_name = p_stat_typ_transaction.period_set_name
1328: AND period_type = p_stat_typ_transaction.period_type;
1329:

Line 3685: gl_periods glp

3681: CURSOR c_pname IS
3682: SELECT
3683: glp.period_name
3684: FROM
3685: gl_periods glp
3686: , gl_ledger_le_v gllv
3687: WHERE gllv.period_set_name = glp.period_set_name
3688: AND gllv.legal_entity_id = p_legal_entity_id
3689: AND gllv.ledger_category_code = 'PRIMARY'

Line 3778: GL_PERIODS

3774: CURSOR c_period IS
3775: SELECT
3776: period_name
3777: FROM
3778: GL_PERIODS
3779: WHERE period_set_name = l_stat_typ_transaction.period_set_name
3780: AND l_movement_transaction.transaction_date between
3781: (start_date) and (end_date)
3782: AND start_date >= l_stat_typ_transaction.start_date

Line 3791: GL_PERIODS

3787: CURSOR c_period1 IS
3788: SELECT
3789: period_name
3790: FROM
3791: GL_PERIODS
3792: WHERE period_set_name = l_stat_typ_transaction.period_set_name
3793: AND trunc(l_movement_transaction.transaction_date) between
3794: trunc(start_date) and trunc(end_date)
3795: AND period_type = l_stat_typ_transaction.period_type