[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 ' ||
1023: fnd_global.user_id,
1024: sysdate
1025: FROM
1026: mtl_kanban_pull_sequences ps,
1027: bom_bill_of_materials bbom,
1028: mtl_item_categories mic,
1029: bom_inventory_components mrp_bic,
1030: mrp_low_level_codes mllc
1031: WHERE mllc.plan_id =
1140: fnd_global.user_id,
1141: sysdate
1142: FROM
1143: mtl_kanban_pull_sequences ps,
1144: bom_bill_of_materials bbom,
1145: mtl_item_categories mic,
1146: bom_inventory_components mrp_bic,
1147: mrp_low_level_codes mllc
1148: WHERE mllc.plan_id =
1280: min(bos.net_planning_percent)
1281: FROM bom_operation_sequences bos,
1282: bom_operational_routings bor,
1283: bom_inventory_components mrp_bic,
1284: bom_bill_of_materials bbom
1285: WHERE bbom.assembly_item_id = mllc.assembly_item_id
1286: AND bbom.organization_id = mllc.organization_id
1287: AND nvl(bbom.alternate_bom_designator, 'xxx') =
1288: nvl(mllc.alternate_designator, 'xxx')