APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_ATTR_FACTORS

Line 105: DELETE FROM jty_dea_attr_factors o

101: DELETE FROM jty_dea_attr_products
102: WHERE source_id = p_source_id
103: AND trans_type_id = p_trans_id;
104:
105: DELETE FROM jty_dea_attr_factors o
106: WHERE NOT EXISTS
107: ( SELECT NULL
108: FROM jty_dea_attr_products i
109: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );

Line 184: DELETE FROM jty_dea_attr_factors o

180: DELETE FROM jty_dea_attr_prod_factors
181: WHERE dea_attr_products_id = l_qual_prd_id_tbl(i);
182: END IF;
183:
184: DELETE FROM jty_dea_attr_factors o
185: WHERE NOT EXISTS
186: ( SELECT NULL
187: FROM jty_dea_attr_products i
188: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );

Line 1128: FROM jty_dea_attr_factors

1124: FOR q_detail in qual_details(qual_name.qual_usg_id) LOOP
1125:
1126: SELECT count(*)
1127: INTO l_exist_qual_detail_count
1128: FROM jty_dea_attr_factors
1129: WHERE qual_usg_id = q_detail.qual_usg_id;
1130:
1131: IF l_exist_qual_detail_count = 0 THEN
1132:

Line 1135: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL

1131: IF l_exist_qual_detail_count = 0 THEN
1132:
1133: BEGIN
1134:
1135: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL
1136: INTO l_qual_factor_id
1137: FROM dual;
1138:
1139: INSERT INTO JTY_DEA_ATTR_FACTORS

Line 1139: INSERT INTO JTY_DEA_ATTR_FACTORS

1135: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL
1136: INTO l_qual_factor_id
1137: FROM dual;
1138:
1139: INSERT INTO JTY_DEA_ATTR_FACTORS
1140: ( DEA_ATTR_FACTORS_ID,
1141: RELATION_FACTOR,
1142: QUAL_USG_ID,
1143: LAST_UPDATED_BY,

Line 1574: FROM jty_dea_attr_factors

1570: BEGIN
1571:
1572: SELECT dea_attr_factors_id
1573: INTO l_qual_factor_id
1574: FROM jty_dea_attr_factors
1575: WHERE qual_usg_id = qual_name.qual_usg_id
1576: AND rownum < 2;
1577:
1578: SELECT JTY_DEA_ATTR_PROD_FACTORS_S.NEXTVAL

Line 1623: update JTY_DEA_ATTR_FACTORS

1619: END LOOP; /* end loop FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST */
1620: END IF; /* end IF (p_qual_prd_tbl.COUNT > 0) */
1621:
1622: /* no need to build the index for the qualifiers with no column mapped to TRANS table */
1623: update JTY_DEA_ATTR_FACTORS
1624: set UPDATE_SELECTIVITY_FLAG = 'N',
1625: USE_TAE_COL_IN_INDEX_FLAG = 'N'
1626: where TAE_COL_MAP is null;
1627:

Line 2127: jty_dea_attr_factors f

2123: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
2124: SELECT p.trans_type_id, count(*) num_components, p.dea_attr_products_id dea_attr_products_id, p.attr_relation_product
2125: FROM jty_dea_attr_products p,
2126: jty_dea_attr_prod_factors pf,
2127: jty_dea_attr_factors f
2128: WHERE p.dea_attr_products_id = pf.dea_attr_products_id
2129: AND pf.dea_attr_factors_id = f.dea_attr_factors_id
2130: AND f.tae_col_map is not null
2131: AND p.source_id = cl_source_id

Line 2158: jty_dea_attr_factors ifc

2154: FROM jty_dea_attr_products p
2155: WHERE NOT EXISTS (SELECT *
2156: FROM jty_dea_attr_products ip,
2157: jty_dea_attr_prod_factors ipf,
2158: jty_dea_attr_factors ifc
2159: WHERE use_tae_col_in_index_flag = 'Y'
2160: AND ip.dea_attr_products_id = ipf.dea_attr_products_id
2161: AND ipf.dea_attr_factors_id = ifc.dea_attr_factors_id
2162: AND ip.dea_attr_products_id = p.dea_attr_products_id)

Line 2194: jty_dea_attr_factors f

2190: FROM (
2191: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2192: FROM jty_dea_attr_products p,
2193: jty_dea_attr_prod_factors pf,
2194: jty_dea_attr_factors f
2195: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2196: AND pf.dea_attr_products_id = p.dea_attr_products_id
2197: AND p.attr_relation_product = cl_set_S.attr_relation_product
2198: AND f.tae_col_map is not null

Line 2208: jty_dea_attr_factors f

2204: FROM (
2205: SELECT DISTINCT p.attr_relation_product, f.tae_col_map, f.input_selectivity
2206: FROM jty_dea_attr_products p,
2207: jty_dea_attr_prod_factors pf,
2208: jty_dea_attr_factors f
2209: WHERE f.dea_attr_factors_id = pf.dea_attr_factors_id
2210: AND pf.dea_attr_products_id = p.dea_attr_products_id
2211: AND p.attr_relation_product = cl_set_L.attr_relation_product
2212: AND f.tae_col_map is not null

Line 2236: jty_dea_attr_factors f

2232: SELECT qual_usg_id, tae_col_map, rownum row_count
2233: FROM (
2234: SELECT f.qual_usg_id, f.relation_factor, f.tae_col_map
2235: FROM jty_dea_attr_prod_factors pf,
2236: jty_dea_attr_factors f
2237: WHERE pf.dea_attr_factors_id = f.dea_attr_factors_id
2238: AND pf.dea_attr_products_id = cl_set_S.dea_attr_products_id
2239: ORDER BY f.input_selectivity)) ilv1,
2240: (