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.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_FIN_ITEMS_KEY_ACC

Line 1217: delete AMW_FIN_ITEMS_KEY_ACC tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID

1213: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1214: and cert.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and cert.OBJECT_TYPE =
1215: 'FIN_STMT');
1216:
1217: delete AMW_FIN_ITEMS_KEY_ACC tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID
1218: from AMW_FIN_STMNT_B base where base.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1219: and base.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and base.end_date is not null
1220: ) and not exists (select cert.STATEMENT_GROUP_ID, cert.FINANCIAL_STATEMENT_ID
1221: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID

Line 2434: AMW_FIN_ITEMS_KEY_ACC

2430:
2431: BEGIN
2432: select count(1) into itmacc_count
2433: from
2434: AMW_FIN_ITEMS_KEY_ACC
2435: where
2436: STATEMENT_GROUP_ID =X_STATEMENT_GROUP_ID and
2437: ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID and
2438: FINANCIAL_STATEMENT_ID = X_FINANCIAL_STATEMENT_ID and

Line 2447: insert into AMW_FIN_ITEMS_KEY_ACC(

2443:
2444: fnd_file.put_line(fnd_file.LOG, 'Warning :- Duplicate Account '|| X_ACCOUNT_GROUP_ID ||' found for Financial Item ' || X_FINANCIAL_ITEM_ID || 'for Statement ' || X_STATEMENT_GROUP_ID );
2445:
2446: else -- if no recrods exists for the unique key
2447: insert into AMW_FIN_ITEMS_KEY_ACC(
2448: STATEMENT_GROUP_ID,
2449: ACCOUNT_GROUP_ID ,
2450: FINANCIAL_STATEMENT_ID,
2451: FINANCIAL_ITEM_ID,