DBA Data[Home] [Help]

APPS.EDW_ITEMS_M_C dependencies on EDW_ITEMS_PKG

Line 1367: PRODUCT_GROUP_FK = edw_items_pkg.get_prod_grp_fk(catset1_category_fk_key,

1363: AND sets.category_set_name = l_item_catset2_name
1364: AND cat.category_set_id = sets.category_set_id),
1365: CATSET3_CATEGORY_FK = edw_itemcustom_m_c.get_product_category_set_fk(catset1_category_fk_key,
1366: product_group_fk_key, instance),
1367: PRODUCT_GROUP_FK = edw_items_pkg.get_prod_grp_fk(catset1_category_fk_key,
1368: product_group_fk_key, instance);
1369:
1370: COMMIT;
1371: ELSE

Line 1403: PRODUCT_GROUP_FK = edw_items_pkg.get_prod_grp_fk(catset1_category_fk_key,

1399: AND cat.inventory_item_id = catset1_category_fk_key
1400: AND sets.control_level = 1
1401: AND sets.category_set_name = l_item_catset3_name
1402: AND cat.category_set_id = sets.category_set_id),
1403: PRODUCT_GROUP_FK = edw_items_pkg.get_prod_grp_fk(catset1_category_fk_key,
1404: product_group_fk_key, instance);
1405:
1406: COMMIT;
1407: END IF;