DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_CATEGORIES

Line 834: FROM MTL_ITEM_CATEGORIES S

830: CURSOR DEFAULT_CAT_ASSIGN_CREATE ( CP_ITEM_ID NUMBER
831: ,CP_ORG_ID NUMBER ) IS
832: SELECT S.CATEGORY_SET_ID,
833: S.CATEGORY_ID
834: FROM MTL_ITEM_CATEGORIES S
835: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
836: AND S.ORGANIZATION_ID = CP_ORG_ID
837: AND EXISTS
838: (SELECT 'X'

Line 859: FROM MTL_ITEM_CATEGORIES S,

855: CURSOR DEFAULT_CAT_ASSIGN_UPDATE ( CP_ITEM_ID NUMBER
856: ,CP_ORG_ID NUMBER ) IS
857: SELECT S.CATEGORY_SET_ID,
858: S.CATEGORY_ID
859: FROM MTL_ITEM_CATEGORIES S,
860: MTL_CATEGORY_SETS_B D
861: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
862: AND S.CATEGORY_SET_ID = D.CATEGORY_SET_ID
863: AND S.ORGANIZATION_ID = CP_ORG_ID