APPS.FLM_KANBAN dependencies on MTL_ITEM_LOCATIONS_KFV

Line 929: mtl_item_locations_kfv mil1, mtl_item_locations_kfv mil2

925: mkd.assembly_subinventory de_item_sub,
926: substr(mil2.concatenated_segments, 0, 5) de_item_loc,
927: demand_quantity quantity
928: FROM mrp_kanban_demand mkd, mtl_system_items msi1, mtl_system_items msi2,
929: mtl_item_locations_kfv mil1, mtl_item_locations_kfv mil2
930: WHERE mkd.kanban_plan_id = l_kp_id
931: AND mkd.inventory_item_id = l_des_compid
932: AND mkd.subinventory = l_des_sub
933: AND (substr(mil1.concatenated_segments, 0, 5) = l_des_loc OR

Line 953: mtl_item_locations_kfv mil1, mtl_item_locations_kfv mil2

949: mkd.assembly_subinventory,
950: substr(mil2.concatenated_segments, 0, 5),
951: demand_quantity
952: FROM mrp_kanban_demand mkd, mtl_system_items msi1, mtl_system_items msi2,
953: mtl_item_locations_kfv mil1, mtl_item_locations_kfv mil2
954: WHERE mkd.kanban_plan_id = l_kp_id
955: AND mkd.organization_id = msi1.organization_id
956: AND mkd.organization_id = msi2.organization_id
957: AND mkd.inventory_item_id = msi1.inventory_item_id

Line 1073: FROM mtl_item_locations_kfv

1069: IF NOT l_des_locid IS NULL
1070: THEN
1071: SELECT substr(concatenated_segments, 0, 5)
1072: INTO l_des_loc
1073: FROM mtl_item_locations_kfv
1074: WHERE inventory_location_id = l_des_locid;
1075: END IF;
1076:
1077: --

Line 1374: mtl_item_locations_kfv mil

1370: substr(mil.concatenated_segments, 0, 5) item_loc,
1371: trunc(demand_date) d,
1372: demand_quantity quantity
1373: FROM mrp_kanban_demand mkd, mtl_system_items msi,
1374: mtl_item_locations_kfv mil
1375: WHERE mkd.kanban_plan_id = l_kp_id
1376: AND (mkd.subinventory = l_des_sub OR
1377: (mkd.subinventory IS NULL AND
1378: l_des_sub IS NULL))

Line 1488: FROM mtl_item_locations_kfv

1484: IF NOT l_des_locid IS NULL
1485: THEN
1486: SELECT substr(concatenated_segments, 0, 5)
1487: INTO l_des_loc
1488: FROM mtl_item_locations_kfv
1489: WHERE inventory_location_id = l_des_locid;
1490: END IF;
1491:
1492: -- retrieve data from database and process it