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_BES_PKG dependencies on AMW_FIN_KEY_ACCT_FLAT

Line 1951: from AMW_FIN_KEY_ACCT_FLAT flat,

1947: ) ACCREL,
1948:
1949: (select temp2.statement_group_id, temp2.financial_statement_id, temp2.financial_item_id,
1950: temp2.account_group_id, temp2.natural_account_id, flat.child_natural_account_id
1951: from AMW_FIN_KEY_ACCT_FLAT flat,
1952: (select distinct temp1.statement_group_id, temp1.financial_statement_id,
1953: case when temp1.financial_item_id = -1 then temp1.child_financial_item_id
1954: else temp1.financial_item_id end financial_item_id, itemaccrel.account_group_id, itemaccrel.natural_account_id
1955: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

Line 2094: from AMW_FIN_KEY_ACCT_FLAT flat,

2090: ) ACCREL,
2091:
2092: (select temp2.statement_group_id, temp2.financial_statement_id, temp2.financial_item_id,
2093: flat.account_group_id, flat.child_natural_account_id
2094: from AMW_FIN_KEY_ACCT_FLAT flat,
2095: (select distinct temp1.statement_group_id, temp1.financial_statement_id,
2096: case when temp1.financial_item_id = -1 then temp1.child_financial_item_id
2097: else temp1.financial_item_id end financial_item_id, itemaccrel.account_group_id, itemaccrel.natural_account_id
2098: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

Line 2172: from AMW_FIN_KEY_ACCT_FLAT flat

2168:
2169: (select flat.account_group_id, flat.parent_natural_account_id natural_account_id, flat.child_natural_account_id
2170: from
2171: (select flat.account_group_id, flat.parent_natural_account_id, flat.child_natural_account_id
2172: from AMW_FIN_KEY_ACCT_FLAT flat
2173: start with (account_group_id, parent_natural_account_id) in
2174: (select account_group_id, natural_account_id
2175: from amw_fin_cert_scope
2176: where fin_certification_id = P_CERTIFICATION_ID)

Line 3617: from AMW_FIN_KEY_ACCT_FLAT acc

3613: AND fika.financial_statement_id = cert.financial_statement_id
3614: AND cert.certification_id = p_certification_id
3615: AND aa.natural_account_id in
3616: ( select acc.child_natural_account_id
3617: from AMW_FIN_KEY_ACCT_FLAT acc
3618: where acc.parent_natural_account_id = fika.natural_account_id
3619: and acc.account_group_id = fika.account_group_id
3620: union all
3621: select acc.natural_account_id

Line 3654: FROM AMW_FIN_KEY_ACCT_FLAT ACC

3650: AND fika.statement_group_id = cert.statement_group_id
3651: AND fika.financial_statement_id = cert.financial_statement_id
3652: AND EXISTS
3653: ( SELECT CHILD_NATURAL_ACCOUNT_ID
3654: FROM AMW_FIN_KEY_ACCT_FLAT ACC
3655: WHERE
3656: ACC.CHILD_NATURAL_ACCOUNT_ID = AA.NATURAL_ACCOUNT_ID
3657: AND ACC.PARENT_NATURAL_ACCOUNT_ID = FIKA.NATURAL_ACCOUNT_ID
3658: AND ACC.ACCOUNT_GROUP_ID = FIKA.ACCOUNT_GROUP_ID

Line 3683: FROM AMW_FIN_KEY_ACCT_FLAT ACC,

3679: EXISTS (
3680: SELECT AA.PK1
3681: FROM AMW_ACCT_ASSOCIATIONS AA,
3682: ( SELECT ACC.CHILD_NATURAL_ACCOUNT_ID NATURAL_ACCOUNT_ID
3683: FROM AMW_FIN_KEY_ACCT_FLAT ACC,
3684: AMW_CERTIFICATION_B CERT,
3685: AMW_FIN_ITEMS_KEY_ACC FIKA
3686: WHERE CERT.CERTIFICATION_ID = p_certification_id
3687: AND FIKA.STATEMENT_GROUP_ID = CERT.STATEMENT_GROUP_ID