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.IEX_STRATEGY_CNT_PUB dependencies on GL_SETS_OF_BOOKS

Line 1128: gl_sets_of_books gl,

1124: AND ps.status = 'OP'
1125: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1126: and not exists(select 1
1127: from iex_promise_details pd,
1128: gl_sets_of_books gl,
1129: ar_system_parameters_all sys
1130: where pd.delinquency_id=del.delinquency_id
1131: and pd.status='COLLECTABLE'
1132: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura

Line 1160: gl_sets_of_books gl,

1156: AND ps.status = 'OP'
1157: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1158: and not exists(select 1
1159: from iex_promise_details pd,
1160: gl_sets_of_books gl,
1161: ar_system_parameters_all sys
1162: where pd.delinquency_id=del.delinquency_id
1163: and pd.status='COLLECTABLE'
1164: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura

Line 1192: gl_sets_of_books gl,

1188: AND ps.status = 'OP'
1189: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1190: and not exists(select 1
1191: from iex_promise_details pd,
1192: gl_sets_of_books gl,
1193: ar_system_parameters_all sys
1194: where pd.delinquency_id=del.delinquency_id
1195: and pd.status='COLLECTABLE'
1196: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura

Line 1224: gl_sets_of_books gl,

1220: AND ps.status = 'OP'
1221: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1222: and not exists(select 1
1223: from iex_promise_details pd,
1224: gl_sets_of_books gl,
1225: ar_system_parameters_all sys
1226: where pd.delinquency_id=del.delinquency_id
1227: and pd.status='COLLECTABLE'
1228: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura