eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 3065: -- Bug 7570437 mtl_item_catalog_groups_kfv should not be used.

3061: RETURN VARCHAR2
3062: IS
3063: l_catalog_category_name VARCHAR2(2020);
3064: BEGIN
3065: -- Bug 7570437 mtl_item_catalog_groups_kfv should not be used.
3066: -- SELECT concatenated_segments
3067: SELECT decode(MICG.item_catalog_group_id, NULL, NULL,
3068: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',101,MICG.item_catalog_group_id,NULL) )
3069: INTO l_catalog_category_name

Line 3070: FROM mtl_item_catalog_groups MICG

3066: -- SELECT concatenated_segments
3067: SELECT decode(MICG.item_catalog_group_id, NULL, NULL,
3068: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',101,MICG.item_catalog_group_id,NULL) )
3069: INTO l_catalog_category_name
3070: FROM mtl_item_catalog_groups MICG
3071: -- FROM mtl_item_catalog_groups_kfv
3072: WHERE item_catalog_group_id = p_item_catalog_group_id;
3073:
3074: RETURN l_catalog_category_name;

Line 3071: -- FROM mtl_item_catalog_groups_kfv

3067: SELECT decode(MICG.item_catalog_group_id, NULL, NULL,
3068: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',101,MICG.item_catalog_group_id,NULL) )
3069: INTO l_catalog_category_name
3070: FROM mtl_item_catalog_groups MICG
3071: -- FROM mtl_item_catalog_groups_kfv
3072: WHERE item_catalog_group_id = p_item_catalog_group_id;
3073:
3074: RETURN l_catalog_category_name;
3075: