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_ACCT_ASSOCIATIONS

Line 1943: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS

1939: temp.ACCOUNT_GROUP_ID,
1940: case when temp.NATURAL_ACCOUNT_ID = -1 then temp.child_natural_account_id else temp.NATURAL_ACCOUNT_ID end natural_account_id,
1941: ACCREL.PK1 organization_id, ACCREL.PK2 process_id
1942: FROM
1943: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
1944: WHERE OBJECT_TYPE = 'PROCESS_ORG'
1945: AND APPROVAL_DATE IS NOT NULL
1946: AND DELETION_APPROVAL_DATE IS NULL
1947: ) ACCREL,

Line 2016: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS

2012:
2013: (SELECT temp.STATEMENT_GROUP_ID, temp.FINANCIAL_STATEMENT_ID, temp.FINANCIAL_ITEM_ID,
2014: temp.ACCOUNT_GROUP_ID,temp.NATURAL_ACCOUNT_ID,ACCREL.PK1 organization_id, ACCREL.PK2 process_id
2015: FROM
2016: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
2017: WHERE OBJECT_TYPE = 'PROCESS_ORG'
2018: AND APPROVAL_DATE IS NOT NULL
2019: AND DELETION_APPROVAL_DATE IS NULL
2020: ) ACCREL,

Line 2086: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS

2082: temp.ACCOUNT_GROUP_ID,
2083: temp.child_natural_account_id natural_account_id,
2084: ACCREL.PK1 organization_id, ACCREL.PK2 process_id
2085: FROM
2086: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
2087: WHERE OBJECT_TYPE = 'PROCESS_ORG'
2088: AND APPROVAL_DATE IS NOT NULL
2089: AND DELETION_APPROVAL_DATE IS NULL
2090: ) ACCREL,

Line 2163: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS

2159: (SELECT temp.ACCOUNT_GROUP_ID,
2160: temp.NATURAL_ACCOUNT_ID,
2161: ACCREL.PK1 organization_id, ACCREL.PK2 process_id
2162: FROM
2163: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
2164: WHERE OBJECT_TYPE = 'PROCESS_ORG'
2165: AND APPROVAL_DATE IS NOT NULL
2166: AND DELETION_APPROVAL_DATE IS NULL
2167: ) ACCREL,

Line 3599: FROM AMW_ACCT_ASSOCIATIONS aa,

3595: -- select all the processes based on the certification_id
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'

Line 3630: FROM AMW_ACCT_ASSOCIATIONS aa,

3626:
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

Line 3681: FROM AMW_ACCT_ASSOCIATIONS AA,

3677: and
3678: /*02.13.07 npanandi: bug 5043879 fix ends*/
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