DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 342: FROM mtl_item_catalog_groups_b ic

338: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
339: WHERE
340: ecp.policy_object_pk1_value =
341: (SELECT TO_CHAR(ic.item_catalog_group_id)
342: FROM mtl_item_catalog_groups_b ic
343: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
344: FROM EGO_OBJ_TYPE_LIFECYCLES olc
345: WHERE olc.object_id = (SELECT OBJECT_ID
346: FROM fnd_objects

Line 2948: FROM mtl_item_catalog_groups_b ic

2944: ENG_CHANGE_POLICIES_V ECP
2945: WHERE --ecp.policy_object_pk1_value = item_dtls.item_catalog_group_id
2946: ecp.policy_object_pk1_value =
2947: (SELECT TO_CHAR(ic.item_catalog_group_id)
2948: FROM mtl_item_catalog_groups_b ic
2949: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
2950: FROM EGO_OBJ_TYPE_LIFECYCLES olc
2951: WHERE olc.object_id = (SELECT OBJECT_ID
2952: FROM fnd_objects