APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_ATTR_FACTORS

Line 95: DELETE FROM jty_dea_attr_factors o

91: DELETE FROM jty_dea_attr_products
92: WHERE source_id = p_source_id
93: AND trans_type_id = p_trans_id;
94:
95: DELETE FROM jty_dea_attr_factors o
96: WHERE NOT EXISTS
97: ( SELECT NULL
98: FROM jty_dea_attr_products i
99: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );

Line 1098: FROM jty_dea_attr_factors

1094: FOR q_detail in qual_details(qual_name.qual_usg_id) LOOP
1095:
1096: SELECT count(*)
1097: INTO l_exist_qual_detail_count
1098: FROM jty_dea_attr_factors
1099: WHERE qual_usg_id = q_detail.qual_usg_id;
1100:
1101: IF l_exist_qual_detail_count = 0 THEN
1102:

Line 1105: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL

1101: IF l_exist_qual_detail_count = 0 THEN
1102:
1103: BEGIN
1104:
1105: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL
1106: INTO l_qual_factor_id
1107: FROM dual;
1108:
1109: INSERT INTO JTY_DEA_ATTR_FACTORS

Line 1109: INSERT INTO JTY_DEA_ATTR_FACTORS

1105: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL
1106: INTO l_qual_factor_id
1107: FROM dual;
1108:
1109: INSERT INTO JTY_DEA_ATTR_FACTORS
1110: ( DEA_ATTR_FACTORS_ID,
1111: RELATION_FACTOR,
1112: QUAL_USG_ID,
1113: LAST_UPDATED_BY,

Line 1544: FROM jty_dea_attr_factors

1540: BEGIN
1541:
1542: SELECT dea_attr_factors_id
1543: INTO l_qual_factor_id
1544: FROM jty_dea_attr_factors
1545: WHERE qual_usg_id = qual_name.qual_usg_id
1546: AND rownum < 2;
1547:
1548: SELECT JTY_DEA_ATTR_PROD_FACTORS_S.NEXTVAL

Line 1593: update JTY_DEA_ATTR_FACTORS

1589: END LOOP; /* end loop FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST */
1590: END IF; /* end IF (p_qual_prd_tbl.COUNT > 0) */
1591:
1592: /* no need to build the index for the qualifiers with no column mapped to TRANS table */
1593: update JTY_DEA_ATTR_FACTORS
1594: set UPDATE_SELECTIVITY_FLAG = 'N',
1595: USE_TAE_COL_IN_INDEX_FLAG = 'N'
1596: where TAE_COL_MAP is null;
1597:

Line 2115: jty_dea_attr_factors f

2111: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
2112: SELECT p.trans_type_id, count(*) num_components, p.dea_attr_products_id dea_attr_products_id, p.attr_relation_product
2113: FROM jty_dea_attr_products p,
2114: jty_dea_attr_prod_factors pf,
2115: jty_dea_attr_factors f
2116: WHERE p.dea_attr_products_id = pf.dea_attr_products_id
2117: AND pf.dea_attr_factors_id = f.dea_attr_factors_id
2118: AND f.tae_col_map is not null
2119: AND p.source_id = cl_source_id

Line 2146: jty_dea_attr_factors ifc

2142: FROM jty_dea_attr_products p
2143: WHERE NOT EXISTS (SELECT *
2144: FROM jty_dea_attr_products ip,
2145: jty_dea_attr_prod_factors ipf,
2146: jty_dea_attr_factors ifc
2147: WHERE use_tae_col_in_index_flag = 'Y'
2148: AND ip.dea_attr_products_id = ipf.dea_attr_products_id
2149: AND ipf.dea_attr_factors_id = ifc.dea_attr_factors_id
2150: AND ip.dea_attr_products_id = p.dea_attr_products_id)

Line 2184: jty_dea_attr_factors f

2180: FROM (
2181: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2182: FROM jty_dea_attr_products p,
2183: jty_dea_attr_prod_factors pf,
2184: jty_dea_attr_factors f
2185: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2186: AND pf.dea_attr_products_id = p.dea_attr_products_id
2187: AND p.attr_relation_product = cl_set_S.attr_relation_product
2188: AND f.tae_col_map is not null

Line 2198: jty_dea_attr_factors f

2194: FROM (
2195: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2196: FROM jty_dea_attr_products p,
2197: jty_dea_attr_prod_factors pf,
2198: jty_dea_attr_factors f
2199: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2200: AND pf.dea_attr_products_id = p.dea_attr_products_id
2201: AND p.attr_relation_product = cl_set_L.attr_relation_product
2202: AND f.tae_col_map is not null

Line 2226: jty_dea_attr_factors f

2222: SELECT qual_usg_id, tae_col_map, rownum row_count
2223: FROM (
2224: SELECT f.qual_usg_id, f.relation_factor, f.tae_col_map
2225: FROM jty_dea_attr_prod_factors pf,
2226: jty_dea_attr_factors f
2227: WHERE pf.dea_attr_factors_id = f.dea_attr_factors_id
2228: AND pf.dea_attr_products_id = cl_set_S.dea_attr_products_id
2229: ORDER BY f.input_selectivity)) ilv1,
2230: (