APPS.INVPAGI2 dependencies on MTL_ITEM_CATALOG_GROUPS_B
Line 122: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
118: SELECT ITEM_NUM_GEN_METHOD
119: FROM
120: (
121: SELECT ICC.ITEM_NUM_GEN_METHOD 122: FROM MTL_ITEM_CATALOG_GROUPS_B ICC 123: WHERE ICC.ITEM_NUM_GEN_METHOD IS NOT NULL
124: AND ICC.ITEM_NUM_GEN_METHOD <> 'I'
125: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
126: START WITH ICC.ITEM_CATALOG_GROUP_ID = cp_catalog_group_id