DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on MTL_ITEM_CATALOG_GROUPS

Line 1890: FROM mtl_item_catalog_groups_b ic

1886: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
1887: WHERE
1888: ecp.policy_object_pk1_value =
1889: (SELECT TO_CHAR(ic.item_catalog_group_id)
1890: FROM mtl_item_catalog_groups_b ic
1891: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
1892: FROM EGO_OBJ_TYPE_LIFECYCLES olc
1893: WHERE olc.object_id = (SELECT OBJECT_ID
1894: FROM fnd_objects

Line 1953: FROM mtl_item_catalog_groups_b ic

1949: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP
1950: WHERE
1951: ecp.policy_object_pk1_value =
1952: (SELECT TO_CHAR(ic.item_catalog_group_id)
1953: FROM mtl_item_catalog_groups_b ic
1954: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
1955: FROM EGO_OBJ_TYPE_LIFECYCLES olc
1956: WHERE olc.object_id = (SELECT OBJECT_ID
1957: FROM fnd_objects

Line 2189: FROM mtl_item_catalog_groups_b ic

2185: ENG_CHANGE_POLICIES_V ECP
2186: WHERE
2187: ecp.policy_object_pk1_value =
2188: (SELECT TO_CHAR(ic.item_catalog_group_id)
2189: FROM mtl_item_catalog_groups_b ic
2190: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
2191: FROM EGO_OBJ_TYPE_LIFECYCLES olc
2192: WHERE olc.object_id = (SELECT OBJECT_ID
2193: FROM fnd_objects

Line 2269: FROM mtl_item_catalog_groups_b ic

2265: ENG_CHANGE_POLICIES_V ECP
2266: WHERE
2267: ecp.policy_object_pk1_value =
2268: (SELECT TO_CHAR(ic.item_catalog_group_id)
2269: FROM mtl_item_catalog_groups_b ic
2270: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
2271: FROM EGO_OBJ_TYPE_LIFECYCLES olc
2272: WHERE olc.object_id = (SELECT OBJECT_ID
2273: FROM fnd_objects

Line 3022: -- Bug 7570437 mtl_item_catalog_groups_kfv should not be used.

3018: RETURN VARCHAR2
3019: IS
3020: l_catalog_category_name VARCHAR2(2020);
3021: BEGIN
3022: -- Bug 7570437 mtl_item_catalog_groups_kfv should not be used.
3023: -- SELECT concatenated_segments
3024: SELECT decode(MICG.item_catalog_group_id, NULL, NULL,
3025: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',101,MICG.item_catalog_group_id,NULL) )
3026: INTO l_catalog_category_name

Line 3027: FROM mtl_item_catalog_groups MICG

3023: -- SELECT concatenated_segments
3024: SELECT decode(MICG.item_catalog_group_id, NULL, NULL,
3025: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',101,MICG.item_catalog_group_id,NULL) )
3026: INTO l_catalog_category_name
3027: FROM mtl_item_catalog_groups MICG
3028: -- FROM mtl_item_catalog_groups_kfv
3029: WHERE item_catalog_group_id = p_item_catalog_group_id;
3030:
3031: RETURN l_catalog_category_name;

Line 3028: -- FROM mtl_item_catalog_groups_kfv

3024: SELECT decode(MICG.item_catalog_group_id, NULL, NULL,
3025: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',101,MICG.item_catalog_group_id,NULL) )
3026: INTO l_catalog_category_name
3027: FROM mtl_item_catalog_groups MICG
3028: -- FROM mtl_item_catalog_groups_kfv
3029: WHERE item_catalog_group_id = p_item_catalog_group_id;
3030:
3031: RETURN l_catalog_category_name;
3032: