DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1030: FROM MTL_ITEM_CATEGORIES S

1026: CURSOR DEFAULT_CAT_ASSIGN_CREATE ( CP_ITEM_ID NUMBER
1027: ,CP_ORG_ID NUMBER ) IS
1028: SELECT S.CATEGORY_SET_ID,
1029: S.CATEGORY_ID
1030: FROM MTL_ITEM_CATEGORIES S
1031: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
1032: AND S.ORGANIZATION_ID = CP_ORG_ID
1033: AND EXISTS
1034: (SELECT 'X'

Line 1055: FROM MTL_ITEM_CATEGORIES S,

1051: CURSOR DEFAULT_CAT_ASSIGN_UPDATE ( CP_ITEM_ID NUMBER
1052: ,CP_ORG_ID NUMBER ) IS
1053: SELECT S.CATEGORY_SET_ID,
1054: S.CATEGORY_ID
1055: FROM MTL_ITEM_CATEGORIES S,
1056: MTL_CATEGORY_SETS_B D
1057: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
1058: AND S.CATEGORY_SET_ID = D.CATEGORY_SET_ID
1059: AND S.ORGANIZATION_ID = CP_ORG_ID