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.GL_MC_INFO dependencies on FA_MC_BOOK_CONTROLS

Line 197: FROM FA_MC_BOOK_CONTROLS MC

193: OR GLR.org_id = NVL(n_org_id,-99))
194: AND (NVL(n_fa_book_code, '-99') = '-99'
195: OR EXISTS
196: (SELECT 'FA book type is enabled'
197: FROM FA_MC_BOOK_CONTROLS MC
198: WHERE MC.set_of_books_id = GLR.target_ledger_id
199: AND MC.book_type_code = n_fa_book_code
200: AND MC.primary_set_of_books_id = GLR.source_ledger_id
201: AND MC.enabled_flag = 'Y'))

Line 1225: /* If the application is FA (140), check based on FA_MC_BOOK_CONTROLS;

1221: IF l_alc_ledger_type = 'SOURCE' THEN
1222: BEGIN
1223: /* It is ALC Source (i.e. ALC_LEDGER_TYPE_CODE = SOURCE) */
1224:
1225: /* If the application is FA (140), check based on FA_MC_BOOK_CONTROLS;
1226: else, based on ORG_ID */
1227: SELECT count(*)
1228: INTO l_count
1229: FROM GL_LEDGER_RELATIONSHIPS GLR

Line 1241: FROM FA_MC_BOOK_CONTROLS MC

1237: OR GLR.org_id = NVL(n_org_id,-99))
1238: AND (NVL(n_fa_book_code, '-99') = '-99'
1239: OR EXISTS
1240: (SELECT 'FA book type is enabled'
1241: FROM FA_MC_BOOK_CONTROLS MC
1242: WHERE MC.set_of_books_id = GLR.target_ledger_id
1243: AND MC.book_type_code = n_fa_book_code
1244: AND MC.primary_set_of_books_id = GLR.source_ledger_id
1245: AND MC.enabled_flag = 'Y'));

Line 1257: /* If the application is FA (140), check based on FA_MC_BOOK_CONTROLS;

1253: ELSIF l_alc_ledger_type = 'TARGET' THEN
1254: BEGIN
1255: /* It is ALC Target (i.e. ALC_LEDGER_TYPE_CODE = TARGET) */
1256:
1257: /* If the application is FA (140), check based on FA_MC_BOOK_CONTROLS;
1258: else, based on ORG_ID */
1259: SELECT count(*)
1260: INTO l_count
1261: FROM GL_LEDGER_RELATIONSHIPS GLR

Line 1273: FROM FA_MC_BOOK_CONTROLS MC

1269: OR GLR.org_id = NVL(n_org_id,-99))
1270: AND (NVL(n_fa_book_code, '-99') = '-99'
1271: OR EXISTS
1272: (SELECT 'FA book type is enabled'
1273: FROM FA_MC_BOOK_CONTROLS MC
1274: WHERE MC.set_of_books_id = GLR.target_ledger_id
1275: AND MC.book_type_code = n_fa_book_code
1276: AND MC.primary_set_of_books_id = GLR.source_ledger_id
1277: AND MC.enabled_flag = 'Y'));

Line 1562: FROM FA_MC_BOOK_CONTROLS MC

1558: OR glr.org_id = NVL(n_org_id,-99))
1559: AND (NVL(n_fa_book_code, '-99') = '-99'
1560: OR EXISTS
1561: (SELECT 'FA book type is enabled'
1562: FROM FA_MC_BOOK_CONTROLS MC
1563: WHERE MC.set_of_books_id = glr.target_ledger_id
1564: AND MC.book_type_code = n_fa_book_code
1565: AND MC.primary_set_of_books_id = glr.source_ledger_id
1566: AND MC.enabled_flag = 'Y'))