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_PLANNING_UTIL dependencies on MRP_KANBAN_DEMAND

Line 134: from mrp_kanban_demand

130:
131: l_interval := 30; -- Can later be replaced with a parameter. Default is 30 days
132: select sum(demand_quantity)/count(distinct demand_date)
133: into l_avg_demand
134: from mrp_kanban_demand
135: where kanban_plan_id = p_kanban_plan_id
136: and organization_id = p_org_id
137: and inventory_item_id = p_item_id
138: and subinventory = p_subinv

Line 924: type t_mrp_kanban_demand is table of mrp_kanban_demand%rowtype index by binary_integer;

920: is
921:
922: l_flm_kanban_demand_intf t_flm_kanban_demand_intf;
923:
924: type t_mrp_kanban_demand is table of mrp_kanban_demand%rowtype index by binary_integer;
925: v_flm_kanban_demand t_mrp_kanban_demand;
926:
927: type t_interface_id is table of FLM_EKB_DEMAND_INTERFACE.interface_id%type index by binary_integer;
928: type t_process_status is table of FLM_EKB_DEMAND_INTERFACE.process_status%type index by binary_integer;

Line 925: v_flm_kanban_demand t_mrp_kanban_demand;

921:
922: l_flm_kanban_demand_intf t_flm_kanban_demand_intf;
923:
924: type t_mrp_kanban_demand is table of mrp_kanban_demand%rowtype index by binary_integer;
925: v_flm_kanban_demand t_mrp_kanban_demand;
926:
927: type t_interface_id is table of FLM_EKB_DEMAND_INTERFACE.interface_id%type index by binary_integer;
928: type t_process_status is table of FLM_EKB_DEMAND_INTERFACE.process_status%type index by binary_integer;
929: type t_error is table of FLM_EKB_DEMAND_INTERFACE.error%type index by binary_integer;

Line 1125: select mrp_kanban_demand_s.nextval into v_flm_kanban_demand(ins_counter).DEMAND_ID from dual;

1121: while l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE <=
1122: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE
1123: loop
1124:
1125: select mrp_kanban_demand_s.nextval into v_flm_kanban_demand(ins_counter).DEMAND_ID from dual;
1126: v_flm_kanban_demand(ins_counter).kanban_plan_id := 0;
1127: v_flm_kanban_demand(ins_counter).organization_id := l_flm_kanban_demand_intf(l_counter).organization_id;
1128: v_flm_kanban_demand(ins_counter).inventory_item_id := l_flm_kanban_demand_intf(l_counter).inventory_item_id;
1129: v_flm_kanban_demand(ins_counter).subinventory := l_flm_kanban_demand_intf(l_counter).subinventory;

Line 1172: INSERT into MRP_KANBAN_DEMAND values v_flm_kanban_demand(ins_index);

1168: l_counter := l_flm_kanban_demand_intf.next(l_counter);
1169: end loop;
1170:
1171: forall ins_index in v_flm_kanban_demand.first..v_flm_kanban_demand.last
1172: INSERT into MRP_KANBAN_DEMAND values v_flm_kanban_demand(ins_index);
1173:
1174: forall upd_index in v_interface_id.first..v_interface_id.last
1175: update FLM_EKB_DEMAND_INTERFACE set
1176: process_status = decode(v_process_status(upd_index),running,completed,v_process_status(upd_index)),

Line 1464: from mrp_kanban_demand mkd,

1460: sum(nvl(demand_quantity,0))
1461: bulk collect into v_dem_pull_seq_id,
1462: v_demand_date,
1463: v_demand_qty
1464: from mrp_kanban_demand mkd,
1465: mtl_kanban_pull_sequences plan
1466: where mkd.kanban_plan_id = l_kanban_plan_id
1467: and mkd.organization_id = plan.organization_id
1468: and mkd.inventory_item_id = plan.inventory_item_id