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.

[Home] [Help]

APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_FIN_CERT_SCOPE_S

Line 269: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,

265: LAST_UPDATE_DATE ,
266: LAST_UPDATE_LOGIN ,
267: SECURITY_GROUP_ID ,
268: OBJECT_VERSION_NUMBER )
269: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
270: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id, case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
271: 1, sysdate, 1, sysdate, 1, null, 1
272: FROM
273: AMW_FIN_PROCESS_FLAT proc,

Line 344: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,

340: LAST_UPDATE_DATE ,
341: LAST_UPDATE_LOGIN ,
342: SECURITY_GROUP_ID ,
343: OBJECT_VERSION_NUMBER )
344: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
345: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id, case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
346: 1, sysdate, 1, sysdate, 1, null, 1
347: FROM
348: AMW_FIN_PROCESS_FLAT proc,

Line 412: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,

408: LAST_UPDATE_DATE ,
409: LAST_UPDATE_LOGIN ,
410: SECURITY_GROUP_ID ,
411: OBJECT_VERSION_NUMBER )
412: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
413: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id, case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
414: 1, sysdate, 1, sysdate, 1, null, 1
415: FROM
416: AMW_FIN_PROCESS_FLAT proc,

Line 488: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, null statement_group_id, null financial_statement_id,

484: LAST_UPDATE_DATE ,
485: LAST_UPDATE_LOGIN ,
486: SECURITY_GROUP_ID ,
487: OBJECT_VERSION_NUMBER )
488: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, null statement_group_id, null financial_statement_id,
489: null financial_item_id,
490: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id,
491: case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
492: 1, sysdate, 1, sysdate, 1, null, 1

Line 1506: from amw_fin_cert_scope scp,

1502: SECURITY_GROUP_ID ,
1503: OBJECT_VERSION_NUMBER )
1504: SELECT distinct 'ACCOUNT' OBJECT_TYPE , fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
1505: account_group_id, natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1506: from amw_fin_cert_scope scp,
1507: amw_risk_associations risk
1508: where risk.pk1 = scp.fin_certification_id
1509: and risk.object_type = 'PROCESS_FINCERT'
1510: and scp.natural_account_id is not null

Line 1517: from amw_fin_cert_scope scp,

1513: and risk.pk1 = p_certification_id
1514: union all
1515: select distinct 'FINANCIAL ITEM' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, financial_item_id,
1516: null account_group_id, null natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1517: from amw_fin_cert_scope scp,
1518: amw_risk_associations risk
1519: where risk.pk1 = scp.fin_certification_id
1520: and risk.object_type = 'PROCESS_FINCERT'
1521: and scp.organization_id = risk.pk2

Line 1527: from amw_fin_cert_scope scp,

1523: and risk.pk1 = p_certification_id
1524: union all
1525: select distinct 'FINANCIAL STATEMENT' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
1526: null account_group_id, null natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1527: from amw_fin_cert_scope scp,
1528: amw_risk_associations risk
1529: where risk.pk1 = scp.fin_certification_id
1530: and risk.object_type = 'PROCESS_FINCERT'
1531: and scp.organization_id = risk.pk2

Line 1631: from amw_fin_cert_scope scp,

1627: SECURITY_GROUP_ID ,
1628: OBJECT_VERSION_NUMBER )
1629: SELECT distinct 'ACCOUNT' OBJECT_TYPE , fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
1630: account_group_id, natural_account_id, organization_id, control_id, control_rev_id, pk5 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1631: from amw_fin_cert_scope scp,
1632: amw_control_associations ctrl
1633: where ctrl.pk1 = scp.fin_certification_id
1634: and ctrl.object_type = 'RISK_FINCERT'
1635: and scp.natural_account_id is not null

Line 1642: from amw_fin_cert_scope scp,

1638: and ctrl.pk1 = p_certification_id
1639: union all
1640: select distinct 'FINANCIAL ITEM' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, financial_item_id,
1641: null account_group_id, null natural_account_id, organization_id, control_id, control_rev_id, pk5 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1642: from amw_fin_cert_scope scp,
1643: amw_control_associations ctrl
1644: where ctrl.pk1 = scp.fin_certification_id
1645: and ctrl.object_type = 'RISK_FINCERT'
1646: and scp.organization_id = ctrl.pk2

Line 1652: from amw_fin_cert_scope scp,

1648: and ctrl.pk1 = p_certification_id
1649: union all
1650: select distinct 'FINANCIAL STATEMENT' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
1651: null account_group_id, null natural_account_id, organization_id, control_id, control_rev_id, pk5 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1652: from amw_fin_cert_scope scp,
1653: amw_control_associations ctrl
1654: where ctrl.pk1 = scp.fin_certification_id
1655: and ctrl.object_type = 'RISK_FINCERT'
1656: and scp.organization_id = ctrl.pk2