DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_FIN_ITEM_FLAT

Line 1965: from AMW_FIN_ITEM_FLAT itemflat,

1961: and cert.statement_group_id = itemb.statement_group_id
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

Line 2035: from AMW_FIN_ITEM_FLAT itemflat,

2031: and cert.statement_group_id = itemb.statement_group_id
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

Line 2108: from AMW_FIN_ITEM_FLAT itemflat,

2104: and cert.statement_group_id = itemb.statement_group_id
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