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_ITEMS_KEY_ACC

Line 1955: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

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,
1956:
1957: (select -1 financial_item_id, itemb.financial_item_id child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
1958: FROM AMW_CERTIFICATION_B cert,
1959: AMW_FIN_STMNT_ITEMS_B itemb

Line 2025: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

2021:
2022: (select distinct temp1.statement_group_id, temp1.financial_statement_id,
2023: case when temp1.financial_item_id = -1 then temp1.child_financial_item_id
2024: else temp1.financial_item_id end financial_item_id, itemaccrel.account_group_id, itemaccrel.natural_account_id
2025: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,
2026:
2027: (select -1 financial_item_id, itemb.financial_item_id child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
2028: FROM AMW_CERTIFICATION_B cert,
2029: AMW_FIN_STMNT_ITEMS_B itemb

Line 2098: from AMW_FIN_ITEMS_KEY_ACC ITEMACCREL,

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,
2099:
2100: (select -1 financial_item_id, itemb.financial_item_id child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
2101: FROM AMW_CERTIFICATION_B cert,
2102: AMW_FIN_STMNT_ITEMS_B itemb

Line 3600: AMW_FIN_ITEMS_KEY_ACC fika,

3596: ---this is for later use after we uptake multiple process certifications
3597: /*CURSOR c_process(p_certification_id NUMBER) IS
3598: SELECT distinct aa.pk1 organization_id, aa.pk2 process_id, po.revision_number, po.process_org_rev_id
3599: FROM AMW_ACCT_ASSOCIATIONS aa,
3600: AMW_FIN_ITEMS_KEY_ACC fika,
3601: AMW_PROCESS_ORGANIZATION po,
3602: AMW_CERTIFICATION_B cert
3603: WHERE aa.object_type = 'PROCESS_ORG'
3604: AND aa.pk1 = po.organization_id

Line 3631: AMW_FIN_ITEMS_KEY_ACC fika,

3627: -- psomanat : 01/09/2007 : Modified the cursor for performance for bug 5683030
3628: /*CURSOR c_process(p_certification_id NUMBER) IS
3629: SELECT distinct aa.pk1 organization_id, aa.pk2 process_id, po.revision_number, po.process_org_rev_id
3630: FROM AMW_ACCT_ASSOCIATIONS aa,
3631: AMW_FIN_ITEMS_KEY_ACC fika,
3632: AMW_PROCESS_ORGANIZATION po,
3633: AMW_CERTIFICATION_B cert
3634: WHERE cert.certification_id = p_certification_id
3635: AND aa.object_type = 'PROCESS_ORG'

Line 3685: AMW_FIN_ITEMS_KEY_ACC FIKA

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
3688: AND FIKA.FINANCIAL_STATEMENT_ID = CERT.FINANCIAL_STATEMENT_ID
3689: AND FIKA.NATURAL_ACCOUNT_ID = ACC.PARENT_NATURAL_ACCOUNT_ID

Line 3695: AMW_FIN_ITEMS_KEY_ACC FIKA

3691: UNION ALL
3692: SELECT ACC.NATURAL_ACCOUNT_ID
3693: FROM AMW_FIN_KEY_ACCOUNTS_B ACC,
3694: AMW_CERTIFICATION_B CERT,
3695: AMW_FIN_ITEMS_KEY_ACC FIKA
3696: WHERE CERT.CERTIFICATION_ID = p_certification_id
3697: AND FIKA.STATEMENT_GROUP_ID = CERT.STATEMENT_GROUP_ID
3698: AND FIKA.FINANCIAL_STATEMENT_ID = CERT.FINANCIAL_STATEMENT_ID
3699: AND FIKA.ACCOUNT_GROUP_ID = ACC.ACCOUNT_GROUP_ID