DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 839: FROM MTL_DEFAULT_CATEGORY_SETS D

835: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
836: AND S.ORGANIZATION_ID = CP_ORG_ID
837: AND EXISTS
838: (SELECT 'X'
839: FROM MTL_DEFAULT_CATEGORY_SETS D
840: WHERE D.CATEGORY_SET_ID = S.CATEGORY_SET_ID
841: AND (D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INVENTORY_ITEM_FLAG, 'Y', 1, 0 )
842: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.PURCHASING_ITEM_FLAG, 'Y', 2, 0 )
843: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INTERNAL_ORDER_FLAG, 'Y', 2, 0 )

Line 867: FROM MTL_DEFAULT_CATEGORY_SETS D

863: AND S.ORGANIZATION_ID = CP_ORG_ID
864: AND (D.CONTROL_LEVEL = 1
865: OR EXISTS
866: (SELECT 'X'
867: FROM MTL_DEFAULT_CATEGORY_SETS D
868: WHERE D.CATEGORY_SET_ID = S.CATEGORY_SET_ID
869: AND (D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INVENTORY_ITEM_FLAG, 'Y', 1, 0 )
870: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.PURCHASING_ITEM_FLAG, 'Y', 2, 0 )
871: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INTERNAL_ORDER_FLAG, 'Y', 2, 0 )