APPS.FII_SNAP_TBL_REFRESH dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 1294: SELECT /*+ index(a fii_fin_cat_type_assgns_u1) */

1290: bitand(cal.record_type_id, 128) = 128 OR
1291: bitand(cal.record_type_id, 256) = 256))
1292:
1293:
1294: SELECT /*+ index(a fii_fin_cat_type_assgns_u1) */
1295: f.ent_year_id year_id,
1296: f.cost_center_id,
1297: f.company_id,
1298: f.fin_category_id,

Line 1663: fii_fin_cat_type_assgns a,

1659:
1660: GROUP BY c1.company_id, c1.cost_center_id, c1.fin_category_id,
1661: c1.user_dim1_id, c1.user_dim2_id, c1.ledger_id, 'BB') f,
1662:
1663: fii_fin_cat_type_assgns a,
1664: fii_com_cc_dim_maps m,
1665: fii_fin_cat_leaf_maps c,
1666: fii_udd1_mappings ud1,
1667: fii_udd2_mappings ud2

Line 1926: fii_fin_cat_type_assgns a,

1922:
1923: GROUP BY b1.company_id, b1.cost_center_id, b1.fin_category_id,
1924: b1.user_dim1_id, b1.user_dim2_id, b1.ledger_id, 'A') f,
1925:
1926: fii_fin_cat_type_assgns a,
1927: fii_com_cc_dim_maps m,
1928: fii_fin_cat_leaf_maps c,
1929: fii_udd1_mappings ud1,
1930: fii_udd2_mappings ud2