APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_KEY_ACCT_FLAT

Line 288: from AMW_FIN_KEY_ACCT_FLAT flat,

284: ) ACCREL,
285:
286: (select temp2.statement_group_id, temp2.financial_statement_id, temp2.financial_item_id,
287: temp2.account_group_id, temp2.natural_account_id, flat.child_natural_account_id
288: from AMW_FIN_KEY_ACCT_FLAT flat,
289: (select distinct temp1.statement_group_id, temp1.financial_statement_id,
290: case when temp1.financial_item_id = -1 then temp1.child_financial_item_id
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,

Line 431: from AMW_FIN_KEY_ACCT_FLAT flat,

427: ) ACCREL,
428:
429: (select temp2.statement_group_id, temp2.financial_statement_id, temp2.financial_item_id,
430: flat.account_group_id, flat.child_natural_account_id
431: from AMW_FIN_KEY_ACCT_FLAT flat,
432: (select distinct temp1.statement_group_id, temp1.financial_statement_id,
433: case when temp1.financial_item_id = -1 then temp1.child_financial_item_id
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,

Line 509: from AMW_FIN_KEY_ACCT_FLAT flat

505:
506: (select flat.account_group_id, flat.parent_natural_account_id natural_account_id, flat.child_natural_account_id
507: from
508: (select flat.account_group_id, flat.parent_natural_account_id, flat.child_natural_account_id
509: from AMW_FIN_KEY_ACCT_FLAT flat
510: start with (account_group_id, parent_natural_account_id) in
511: (select account_group_id, natural_account_id
512: from amw_fin_cert_scope
513: where fin_certification_id = P_CERTIFICATION_ID)