[Home] [Help]
736: -- is specified, then we impose extra where conditions and join a couple
737: -- of more tables as seen in the sql statement we just built). As we get
738: -- the inventory item id from mtl_system_items , we also get location
739: -- information for this item by joining to bom_inventory_components. We
740: -- are not satisfied with that. So we join bom_bill_of_materials
741: -- to get the assembly_item_id and its location information which is
742: -- (if its a kanban item) stored (hopefully) in mtl_kanban_pull_sequences
743: -- table. The catch here is that for a production kind of source type in
744: -- in the replenishment chain we specify a line for the source. We want
823: '( SELECT /*+ no_merge */ distinct inventory_item_id ,organization_id ' ||
824: ' FROM mtl_kanban_pull_sequences ' ||
825: ' WHERE kanban_plan_id = :b_PRODUCTION_KANBAN ) iv, ' ||
826: 'bom_inventory_components mrp_bic, ' ||
827: 'bom_bill_of_materials bbom, ' ||
828: 'mtl_kanban_pull_sequences ps, ' ||
829: l_additional_tables ||
830: 'mtl_system_items msi2 ' ||
831: 'WHERE mkp.kanban_plan_id = :b_kanban_plan_id ' ||
1024: fnd_global.user_id,
1025: sysdate
1026: FROM
1027: mtl_kanban_pull_sequences ps,
1028: bom_bill_of_materials bbom,
1029: mtl_item_categories mic,
1030: bom_inventory_components mrp_bic,
1031: mrp_low_level_codes mllc
1032: WHERE mllc.plan_id =
1141: fnd_global.user_id,
1142: sysdate
1143: FROM
1144: mtl_kanban_pull_sequences ps,
1145: bom_bill_of_materials bbom,
1146: mtl_item_categories mic,
1147: bom_inventory_components mrp_bic,
1148: mrp_low_level_codes mllc
1149: WHERE mllc.plan_id =
1281: min(bos.net_planning_percent)
1282: FROM bom_operation_sequences bos,
1283: bom_operational_routings bor,
1284: bom_inventory_components mrp_bic,
1285: bom_bill_of_materials bbom
1286: WHERE bbom.assembly_item_id = mllc.assembly_item_id
1287: AND bbom.organization_id = mllc.organization_id
1288: AND nvl(bbom.alternate_bom_designator, 'xxx') =
1289: nvl(mllc.alternate_designator, 'xxx')