APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_ACCT_ASSOCIATIONS

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

276: temp.ACCOUNT_GROUP_ID,
277: case when temp.NATURAL_ACCOUNT_ID = -1 then temp.child_natural_account_id else temp.NATURAL_ACCOUNT_ID end natural_account_id,
278: ACCREL.PK1 organization_id, ACCREL.PK2 process_id
279: FROM
280: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
281: WHERE OBJECT_TYPE = 'PROCESS_ORG'
282: AND APPROVAL_DATE IS NOT NULL
283: AND DELETION_APPROVAL_DATE IS NULL
284: ) ACCREL,

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

349:
350: (SELECT temp.STATEMENT_GROUP_ID, temp.FINANCIAL_STATEMENT_ID, temp.FINANCIAL_ITEM_ID,
351: temp.ACCOUNT_GROUP_ID,temp.NATURAL_ACCOUNT_ID,ACCREL.PK1 organization_id, ACCREL.PK2 process_id
352: FROM
353: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
354: WHERE OBJECT_TYPE = 'PROCESS_ORG'
355: AND APPROVAL_DATE IS NOT NULL
356: AND DELETION_APPROVAL_DATE IS NULL
357: ) ACCREL,

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

419: temp.ACCOUNT_GROUP_ID,
420: temp.child_natural_account_id natural_account_id,
421: ACCREL.PK1 organization_id, ACCREL.PK2 process_id
422: FROM
423: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
424: WHERE OBJECT_TYPE = 'PROCESS_ORG'
425: AND APPROVAL_DATE IS NOT NULL
426: AND DELETION_APPROVAL_DATE IS NULL
427: ) ACCREL,

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

496: (SELECT temp.ACCOUNT_GROUP_ID,
497: temp.NATURAL_ACCOUNT_ID,
498: ACCREL.PK1 organization_id, ACCREL.PK2 process_id
499: FROM
500: (SELECT NATURAL_ACCOUNT_ID, PK1, PK2 FROM AMW_ACCT_ASSOCIATIONS
501: WHERE OBJECT_TYPE = 'PROCESS_ORG'
502: AND APPROVAL_DATE IS NOT NULL
503: AND DELETION_APPROVAL_DATE IS NULL
504: ) ACCREL,