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_STMNT_ITEMS_B

Line 1959: AMW_FIN_STMNT_ITEMS_B itemb

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
1960: WHERE cert.CERTIFICATION_ID = P_CERTIFICATION_ID
1961: and cert.statement_group_id = itemb.statement_group_id
1962: and cert.financial_statement_id = itemb.financial_statement_id
1963: UNION ALL

Line 1966: AMW_FIN_STMNT_ITEMS_B itemb,

1962: and cert.financial_statement_id = itemb.financial_statement_id
1963: UNION ALL
1964: select itemb.financial_item_id, itemflat.child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
1965: from AMW_FIN_ITEM_FLAT itemflat,
1966: AMW_FIN_STMNT_ITEMS_B itemb,
1967: AMW_CERTIFICATION_B cert
1968: where
1969: cert.CERTIFICATION_ID = P_CERTIFICATION_ID
1970: and cert.statement_group_id = itemb.statement_group_id

Line 2029: AMW_FIN_STMNT_ITEMS_B itemb

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
2030: WHERE cert.CERTIFICATION_ID = P_CERTIFICATION_ID
2031: and cert.statement_group_id = itemb.statement_group_id
2032: and cert.financial_statement_id = itemb.financial_statement_id
2033: UNION ALL

Line 2036: AMW_FIN_STMNT_ITEMS_B itemb,

2032: and cert.financial_statement_id = itemb.financial_statement_id
2033: UNION ALL
2034: select itemb.financial_item_id, itemflat.child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
2035: from AMW_FIN_ITEM_FLAT itemflat,
2036: AMW_FIN_STMNT_ITEMS_B itemb,
2037: AMW_CERTIFICATION_B cert
2038: where
2039: cert.CERTIFICATION_ID = P_CERTIFICATION_ID
2040: and cert.statement_group_id = itemb.statement_group_id

Line 2102: AMW_FIN_STMNT_ITEMS_B itemb

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
2103: WHERE cert.CERTIFICATION_ID = P_CERTIFICATION_ID
2104: and cert.statement_group_id = itemb.statement_group_id
2105: and cert.financial_statement_id = itemb.financial_statement_id
2106: UNION ALL

Line 2109: AMW_FIN_STMNT_ITEMS_B itemb,

2105: and cert.financial_statement_id = itemb.financial_statement_id
2106: UNION ALL
2107: select itemb.financial_item_id, itemflat.child_financial_item_id, itemb.statement_group_id, itemb.financial_statement_id
2108: from AMW_FIN_ITEM_FLAT itemflat,
2109: AMW_FIN_STMNT_ITEMS_B itemb,
2110: AMW_CERTIFICATION_B cert
2111: where
2112: cert.CERTIFICATION_ID = P_CERTIFICATION_ID
2113: and cert.statement_group_id = itemb.statement_group_id