DBA Data[Home] [Help]

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1372: FROM mtl_onhand_quantities_detail moqd,

1368: select mkps.pull_sequence_id,mkps.organization_id,mkps.kanban_plan_id,mkps.inventory_item_id,mkps.Subinventory_name,mkps.locator_id,
1369: mkps.Safety_Stock_Days,decode(nvl(mkps.Kanban_size,0),0,1,mkps.Kanban_size) Kanban_size,decode(nvl(mkps.Number_of_cards,0),0,1,Number_of_cards) Number_of_cards,
1370: mkps.avg_dependent_demand,nvl(sum(nvl(moqd.primary_transaction_quantity,0)),0),nvl(ceil(mkps.replenishment_lead_time),0)
1371: bulk collect into v_plan_pull_seq_tbl
1372: FROM mtl_onhand_quantities_detail moqd,
1373: mtl_kanban_pull_sequences mkps
1374: WHERE moqd.inventory_item_id(+) = mkps.inventory_item_id
1375: AND moqd.organization_id(+) = mkps.organization_id
1376: AND moqd.subinventory_code(+) = mkps.subinventory_name