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_FINSTMT_CERT_MIG_PKG dependencies on AMW_CERTIFICATION_B

Line 295: FROM AMW_CERTIFICATION_B cert,

291: else temp1.financial_item_id end financial_item_id, itemaccrel.account_group_id, itemaccrel.natural_account_id
292: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,
293:
294: (select -1 financial_item_id, itemb.financial_item_id child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
295: FROM AMW_CERTIFICATION_B cert,
296: AMW_FIN_STMNT_ITEMS_B itemb
297: WHERE cert.CERTIFICATION_ID = P_CERTIFICATION_ID
298: and cert.statement_group_id = itemb.statement_group_id
299: and cert.financial_statement_id = itemb.financial_statement_id

Line 304: AMW_CERTIFICATION_B cert

300: UNION ALL
301: select itemb.financial_item_id, itemflat.child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
302: from AMW_FIN_ITEM_FLAT itemflat,
303: AMW_FIN_STMNT_ITEMS_B itemb,
304: AMW_CERTIFICATION_B cert
305: where
306: cert.CERTIFICATION_ID = P_CERTIFICATION_ID
307: and cert.statement_group_id = itemb.statement_group_id
308: and cert.financial_statement_id = itemb.financial_statement_id

Line 365: FROM AMW_CERTIFICATION_B cert,

361: else temp1.financial_item_id end financial_item_id, itemaccrel.account_group_id, itemaccrel.natural_account_id
362: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,
363:
364: (select -1 financial_item_id, itemb.financial_item_id child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
365: FROM AMW_CERTIFICATION_B cert,
366: AMW_FIN_STMNT_ITEMS_B itemb
367: WHERE cert.CERTIFICATION_ID = P_CERTIFICATION_ID
368: and cert.statement_group_id = itemb.statement_group_id
369: and cert.financial_statement_id = itemb.financial_statement_id

Line 374: AMW_CERTIFICATION_B cert

370: UNION ALL
371: select itemb.financial_item_id, itemflat.child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
372: from AMW_FIN_ITEM_FLAT itemflat,
373: AMW_FIN_STMNT_ITEMS_B itemb,
374: AMW_CERTIFICATION_B cert
375: where
376: cert.CERTIFICATION_ID = P_CERTIFICATION_ID
377: and cert.statement_group_id = itemb.statement_group_id
378: and cert.financial_statement_id = itemb.financial_statement_id

Line 438: FROM AMW_CERTIFICATION_B cert,

434: else temp1.financial_item_id end financial_item_id, itemaccrel.account_group_id, itemaccrel.natural_account_id
435: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,
436:
437: (select -1 financial_item_id, itemb.financial_item_id child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
438: FROM AMW_CERTIFICATION_B cert,
439: AMW_FIN_STMNT_ITEMS_B itemb
440: WHERE cert.CERTIFICATION_ID = P_CERTIFICATION_ID
441: and cert.statement_group_id = itemb.statement_group_id
442: and cert.financial_statement_id = itemb.financial_statement_id

Line 447: AMW_CERTIFICATION_B cert

443: UNION ALL
444: select itemb.financial_item_id, itemflat.child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
445: from AMW_FIN_ITEM_FLAT itemflat,
446: AMW_FIN_STMNT_ITEMS_B itemb,
447: AMW_CERTIFICATION_B cert
448: where
449: cert.CERTIFICATION_ID = P_CERTIFICATION_ID
450: and cert.statement_group_id = itemb.statement_group_id
451: and cert.financial_statement_id = itemb.financial_statement_id