DBA Data[Home] [Help]

APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 382: FROM MTL_ITEM_CATALOG_GROUPS_B micgb

378: ELSE NULL
379: END
380: ) NEW_ITEM_REQ_CHANGE_TYPE_ID
381:
382: FROM MTL_ITEM_CATALOG_GROUPS_B micgb
383: CONNECT BY PRIOR micgb.PARENT_CATALOG_GROUP_ID = micgb.ITEM_CATALOG_GROUP_ID
384: START WITH micgb.ITEM_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
385: )) = eng_types.change_order_type_id
386: AND mp.organization_id = msii.organization_id

Line 404: mtl_item_catalog_groups_b micgb

400: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
401: ENG_CHANGE_ORDER_TYPES_VL eng_types,
402: MTL_PARAMETERS mp,
403: ego_item_cat_denorm_hier heir,
404: mtl_item_catalog_groups_b micgb
405: WHERE msii.set_process_id = P_BATCH_ID
406: AND PROCESS_FLAG = l_process_flag
407: AND mp.organization_id = msii.organization_id
408: AND msii.item_catalog_group_id = heir.CHILD_CATALOG_GROUP_ID and

Line 423: FROM MTL_ITEM_CATALOG_GROUPS_B micgb

419: ELSE NULL
420: END
421: ) NEW_ITEM_REQ_CHANGE_TYPE_ID
422:
423: FROM MTL_ITEM_CATALOG_GROUPS_B micgb
424: CONNECT BY PRIOR micgb.PARENT_CATALOG_GROUP_ID = micgb.ITEM_CATALOG_GROUP_ID
425: START WITH micgb.ITEM_CATALOG_GROUP_ID = msii.ITEM_CATALOG_GROUP_ID
426: ) AS type_name,
427: msii.organization_id