eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_KANBAN dependencies on MRP_KANBAN_DEMAND

Line 928: FROM mrp_kanban_demand mkd, mtl_system_items msi1, mtl_system_items msi2,

924: mkd.assembly_item_id de_item_id,
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

Line 952: FROM mrp_kanban_demand mkd, mtl_system_items msi1, mtl_system_items msi2,

948: msi2.segment1, mkd.assembly_item_id,
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

Line 1373: FROM mrp_kanban_demand mkd, mtl_system_items msi,

1369: mkd.subinventory item_sub,
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