DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_ITEM_FLAT

Line 302: from AMW_FIN_ITEM_FLAT itemflat,

298: and cert.statement_group_id = itemb.statement_group_id
299: and cert.financial_statement_id = itemb.financial_statement_id
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

Line 372: from AMW_FIN_ITEM_FLAT itemflat,

368: and cert.statement_group_id = itemb.statement_group_id
369: and cert.financial_statement_id = itemb.financial_statement_id
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

Line 445: from AMW_FIN_ITEM_FLAT itemflat,

441: and cert.statement_group_id = itemb.statement_group_id
442: and cert.financial_statement_id = itemb.financial_statement_id
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