APPS.AS_SALES_LEAD_LINES_PVT dependencies on MTL_SYSTEM_ITEMS

Line 355: FROM mtl_system_items

351: IS
352: CURSOR C_Inventory_Item_Exists (X_Inventory_Item_Id NUMBER,
353: X_Organization_Id NUMBER) IS
354: SELECT 'X'
355: FROM mtl_system_items
356: WHERE inventory_item_id = X_Inventory_Item_Id
357: and organization_id = X_Organization_Id;
358: l_val VARCHAR2(1);
359: BEGIN

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