DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 330: FROM mtl_item_catalog_groups_b ic

326: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
327: WHERE
328: ecp.policy_object_pk1_value =
329: (SELECT TO_CHAR(ic.item_catalog_group_id)
330: FROM mtl_item_catalog_groups_b ic
331: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
332: FROM EGO_OBJ_TYPE_LIFECYCLES olc
333: WHERE olc.object_id = (SELECT OBJECT_ID
334: FROM fnd_objects

Line 2858: FROM mtl_item_catalog_groups_b ic

2854: ENG_CHANGE_POLICIES_V ECP
2855: WHERE --ecp.policy_object_pk1_value = item_dtls.item_catalog_group_id
2856: ecp.policy_object_pk1_value =
2857: (SELECT TO_CHAR(ic.item_catalog_group_id)
2858: FROM mtl_item_catalog_groups_b ic
2859: WHERE EXISTS (SELECT olc.object_classification_code CatalogId
2860: FROM EGO_OBJ_TYPE_LIFECYCLES olc
2861: WHERE olc.object_id = (SELECT OBJECT_ID
2862: FROM fnd_objects