DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 1035: FROM MTL_DEFAULT_CATEGORY_SETS D

1031: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
1032: AND S.ORGANIZATION_ID = CP_ORG_ID
1033: AND EXISTS
1034: (SELECT 'X'
1035: FROM MTL_DEFAULT_CATEGORY_SETS D
1036: WHERE D.CATEGORY_SET_ID = S.CATEGORY_SET_ID
1037: AND (D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INVENTORY_ITEM_FLAG, 'Y', 1, 0 )
1038: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.PURCHASING_ITEM_FLAG, 'Y', 2, 0 )
1039: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INTERNAL_ORDER_FLAG, 'Y', 2, 0 )

Line 1063: FROM MTL_DEFAULT_CATEGORY_SETS D

1059: AND S.ORGANIZATION_ID = CP_ORG_ID
1060: AND (D.CONTROL_LEVEL = 1
1061: OR EXISTS
1062: (SELECT 'X'
1063: FROM MTL_DEFAULT_CATEGORY_SETS D
1064: WHERE D.CATEGORY_SET_ID = S.CATEGORY_SET_ID
1065: AND (D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INVENTORY_ITEM_FLAG, 'Y', 1, 0 )
1066: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.PURCHASING_ITEM_FLAG, 'Y', 2, 0 )
1067: OR D.FUNCTIONAL_AREA_ID = DECODE( G_Item_Rec.INTERNAL_ORDER_FLAG, 'Y', 2, 0 )