DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_ITEMS_KEY_ACC

Line 292: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

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,
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

Line 362: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

358:
359: (select distinct temp1.statement_group_id, temp1.financial_statement_id,
360: case when temp1.financial_item_id = -1 then temp1.child_financial_item_id
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

Line 435: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

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,
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