DBA Data[Home] [Help]

APPS.EGO_UI_ITEM_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 2197: from mtl_item_catalog_groups_b b

2193: from mtl_system_items_b a
2194: where item_catalog_group_id
2195: in(
2196: select item_catalog_group_id
2197: from mtl_item_catalog_groups_b b
2198: connect by prior item_catalog_group_id = parent_catalog_group_id
2199: start with b.item_catalog_group_id =p_catalog_group_id
2200: )
2201: and a.organization_id = p_organization_id

Line 2209: from mtl_item_catalog_groups_b b

2205: from mtl_system_items_b a
2206: where item_catalog_group_id
2207: in(
2208: select item_catalog_group_id
2209: from mtl_item_catalog_groups_b b
2210: connect by prior item_catalog_group_id = parent_catalog_group_id
2211: start with b.item_catalog_group_id =p_catalog_group_id
2212: )
2213: and a.organization_id = p_organization_id;