APPS.AS_SALES_LEAD_LINES_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1033: FROM MTL_SYSTEM_ITEMS_B_KFV B, MTL_ITEM_CATEGORIES MIC,

1029: and PURCHASE_interest = 'Y';
1030:
1031: CURSOR C_Get_Category_INFO (X_prod_Id NUMBER, X_Org_Id NUMBER) IS
1032: SELECT P.CATEGORY_ID CAT_ID, P.CATEGORY_SET_ID CAT_SET_ID
1033: FROM MTL_SYSTEM_ITEMS_B_KFV B, MTL_ITEM_CATEGORIES MIC,
1034: ENI_PROD_DEN_HRCHY_PARENTS_V P
1035: WHERE (MIC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
1036: AND MIC.ORGANIZATION_ID = B.ORGANIZATION_ID
1037: AND B.ORGANIZATION_ID = X_Org_Id