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

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

1928: LAST_UPDATE_DATE ,
1929: LAST_UPDATE_LOGIN ,
1930: SECURITY_GROUP_ID ,
1931: OBJECT_VERSION_NUMBER )
1932: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
1933: 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,
1934: 1, sysdate, 1, sysdate, 1, null, 1
1935: FROM
1936: AMW_FIN_PROCESS_FLAT proc,

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

2003: LAST_UPDATE_DATE ,
2004: LAST_UPDATE_LOGIN ,
2005: SECURITY_GROUP_ID ,
2006: OBJECT_VERSION_NUMBER )
2007: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
2008: 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,
2009: 1, sysdate, 1, sysdate, 1, null, 1
2010: FROM
2011: AMW_FIN_PROCESS_FLAT proc,

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

2071: LAST_UPDATE_DATE ,
2072: LAST_UPDATE_LOGIN ,
2073: SECURITY_GROUP_ID ,
2074: OBJECT_VERSION_NUMBER )
2075: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
2076: 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,
2077: 1, sysdate, 1, sysdate, 1, null, 1
2078: FROM
2079: AMW_FIN_PROCESS_FLAT proc,

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

2147: LAST_UPDATE_DATE ,
2148: LAST_UPDATE_LOGIN ,
2149: SECURITY_GROUP_ID ,
2150: OBJECT_VERSION_NUMBER )
2151: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, null statement_group_id, null financial_statement_id,
2152: null financial_item_id,
2153: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id,
2154: case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
2155: 1, sysdate, 1, sysdate, 1, null, 1

Line 2286: from amw_fin_cert_scope scp,

2282: SECURITY_GROUP_ID ,
2283: OBJECT_VERSION_NUMBER )
2284: SELECT distinct 'ACCOUNT' OBJECT_TYPE , fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
2285: account_group_id, natural_account_id, organization_id, control_id, control_rev_id, pk5 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
2286: from amw_fin_cert_scope scp,
2287: amw_control_associations ctrl
2288: where ctrl.pk1 = scp.fin_certification_id
2289: and ctrl.object_type = 'RISK_FINCERT'
2290: and scp.natural_account_id is not null

Line 2297: from amw_fin_cert_scope scp,

2293: and ctrl.pk1 = p_certification_id
2294: union all
2295: select distinct 'FINANCIAL ITEM' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, financial_item_id,
2296: 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
2297: from amw_fin_cert_scope scp,
2298: amw_control_associations ctrl
2299: where ctrl.pk1 = scp.fin_certification_id
2300: and ctrl.object_type = 'RISK_FINCERT'
2301: and scp.organization_id = ctrl.pk2

Line 2307: from amw_fin_cert_scope scp,

2303: and ctrl.pk1 = p_certification_id
2304: union all
2305: select distinct 'FINANCIAL STATEMENT' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
2306: 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
2307: from amw_fin_cert_scope scp,
2308: amw_control_associations ctrl
2309: where ctrl.pk1 = scp.fin_certification_id
2310: and ctrl.object_type = 'RISK_FINCERT'
2311: and scp.organization_id = ctrl.pk2

Line 2410: from amw_fin_cert_scope scp,

2406: SECURITY_GROUP_ID ,
2407: OBJECT_VERSION_NUMBER )
2408: SELECT distinct 'ACCOUNT' OBJECT_TYPE , fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
2409: 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
2410: from amw_fin_cert_scope scp,
2411: amw_risk_associations risk
2412: where risk.pk1 = scp.fin_certification_id
2413: and risk.object_type = 'PROCESS_FINCERT'
2414: and scp.natural_account_id is not null

Line 2421: from amw_fin_cert_scope scp,

2417: and risk.pk1 = p_certification_id
2418: union all
2419: select distinct 'FINANCIAL ITEM' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, financial_item_id,
2420: 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
2421: from amw_fin_cert_scope scp,
2422: amw_risk_associations risk
2423: where risk.pk1 = scp.fin_certification_id
2424: and risk.object_type = 'PROCESS_FINCERT'
2425: and scp.organization_id = risk.pk2

Line 2431: from amw_fin_cert_scope scp,

2427: and risk.pk1 = p_certification_id
2428: union all
2429: select distinct 'FINANCIAL STATEMENT' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
2430: 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
2431: from amw_fin_cert_scope scp,
2432: amw_risk_associations risk
2433: where risk.pk1 = scp.fin_certification_id
2434: and risk.object_type = 'PROCESS_FINCERT'
2435: and scp.organization_id = risk.pk2

Line 4299: AND EXISTS ( SELECT 'Y' FROM AMW_FIN_CERT_SCOPE scp

4295: FROM AMW_FIN_PROCESS_EVAL_SUM sum
4296: WHERE sum.fin_certification_id = p_certification_id
4297: AND sum.organization_id = p_organization_id
4298: AND sum.process_id = p_process_id
4299: AND EXISTS ( SELECT 'Y' FROM AMW_FIN_CERT_SCOPE scp
4300: WHERE scp.fin_certification_id = sum.fin_certification_id
4301: and scp.organization_id = sum.organization_id
4302: and scp.process_id = sum.process_id
4303: and scp.process_id is not null);