DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 111: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv

107: SELECT organization_id INTO l_id FROM mtl_parameters
108: WHERE organization_code = l_pk1;
109: WHEN G_ITEM_CATALOG_GROUP THEN
110: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
111: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv
112: WHERE concatenated_segments = l_pk1;
113: WHEN G_LIFECYCLE THEN
114: l_pk1 := ID_COL_VALUE('name',p_pk_col_name_val_pairs);
115: SELECT proj_element_id INTO l_id FROM pa_ego_lifecycles_v

Line 190: FROM mtl_item_catalog_groups_kfv

186: WHERE organization_id = l_pk1;
187: WHEN G_ITEM_CATALOG_GROUP THEN
188: l_pk1 := ID_COL_VALUE('item_catalog_group_id',p_pk_col_name_val_pairs);
189: SELECT concatenated_segments INTO l_code
190: FROM mtl_item_catalog_groups_kfv
191: WHERE item_catalog_group_id = l_pk1;
192: WHEN G_LIFECYCLE THEN
193: l_pk1 := ID_COL_VALUE('proj_element_id',p_pk_col_name_val_pairs);
194: SELECT name INTO l_code