DBA Data[Home] [Help]

APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 365: FROM MTL_ITEM_CATALOG_GROUPS_B micgb

361: ELSE NULL
362: END
363: ) NEW_ITEM_REQ_CHANGE_TYPE_ID
364:
365: FROM MTL_ITEM_CATALOG_GROUPS_B micgb
366: CONNECT BY PRIOR micgb.PARENT_CATALOG_GROUP_ID = micgb.ITEM_CATALOG_GROUP_ID
367: START WITH micgb.ITEM_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
368: )) = eng_types.change_order_type_id
369: AND mp.organization_id = msii.organization_id

Line 386: mtl_item_catalog_groups_b micgb

382: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
383: ENG_CHANGE_ORDER_TYPES_VL eng_types,
384: MTL_PARAMETERS mp,
385: ego_item_cat_denorm_hier heir,
386: mtl_item_catalog_groups_b micgb
387: WHERE msii.set_process_id = P_BATCH_ID
388: AND PROCESS_FLAG = l_process_flag
389: AND mp.organization_id = msii.organization_id
390: AND msii.item_catalog_group_id = heir.CHILD_CATALOG_GROUP_ID and