APPS.FLM_KANBAN dependencies on MTL_SYSTEM_ITEMS

Line 97: mtl_system_items msi

93: decode(bic.supply_subinventory,null,msi.wip_supply_subinventory,bic.supply_subinventory),
94: decode(bic.supply_subinventory,null,msi.wip_supply_locator_id,bic.supply_locator_id)
95: FROM bom_bill_of_materials bbom,
96: bom_inventory_components bic,
97: mtl_system_items msi
98: WHERE bbom.organization_id = i_org_id AND
99: bbom.alternate_bom_designator is null AND
100: bbom.assembly_item_id = l_q_item_id AND
101: bbom.common_bill_sequence_id = bic.bill_sequence_id AND

Line 119: mtl_system_items msi

115: decode(bic.supply_subinventory,null,msi.wip_supply_subinventory,bic.supply_subinventory),
116: decode(bic.supply_subinventory,null,msi.wip_supply_locator_id,bic.supply_locator_id)
117: FROM bom_bill_of_materials bbom,
118: bom_inventory_components bic,
119: mtl_system_items msi
120: WHERE bbom.organization_id = i_org_id AND
121: -- nvl(bbom.alternate_bom_designator, 'NONE') = nvl(l_alt, 'NONE') AND
122: bbom.assembly_item_id = l_q_item_id AND
123: bbom.common_bill_sequence_id = bic.bill_sequence_id AND

Line 142: mtl_system_items msi

138: decode(bic.supply_subinventory,null,msi.wip_supply_subinventory,bic.supply_subinventory),
139: decode(bic.supply_subinventory,null,msi.wip_supply_locator_id,bic.supply_locator_id)
140: FROM bom_bill_of_materials bbom,
141: bom_inventory_components bic,
142: mtl_system_items msi
143: WHERE bbom.organization_id = i_org_id AND
144: -- bbom.alternate_bom_designator IS NULL AND
145: bbom.common_bill_sequence_id = bic.bill_sequence_id AND
146: (6=decode(bic.wip_supply_type,null,msi.wip_supply_type,bic.wip_supply_type) OR

Line 257: mtl_system_items msi

253: from
254: bom_bill_of_materials bom,
255: bom_operational_routings bor,
256: bom_inventory_components bic,
257: mtl_system_items msi
258: where
259: bom.organization_id = p_org_id and
260: bom.organization_id = bor.organization_id and
261: bom.assembly_item_id = bor.assembly_item_id and

Line 290: mtl_system_items msi

286: -1
287: from
288: bom_bill_of_materials bom,
289: bom_inventory_components bic,
290: mtl_system_items msi
291: where
292: bom.organization_id = p_org_id and
293: bom.assembly_item_id = p_assembly_item_id and
294: ((bom.alternate_bom_designator = p_alt) or

Line 682: 'FROM mtl_system_items msi ' ||

678: -- DBMS_OUTPUT.PUT_LINE('Where Clause GENERATED:');
679: --DBMS_OUTPUT.PUT_LINE(l_id_where_clause);
680:
681: l_sql_stmt := 'SELECT DISTINCT inventory_item_id ' ||
682: 'FROM mtl_system_items msi ' ||
683: 'WHERE organization_id = :org_id' || ' ';
684:
685: flm_util.add_bind(':org_id', i_org_id);
686:

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

Line 1480: FROM mtl_system_items

1476: WHERE kanban_plan_id = l_kp_id;
1477:
1478: SELECT DISTINCT segment1
1479: INTO l_des_comp
1480: FROM mtl_system_items
1481: WHERE inventory_item_id = l_des_compid AND
1482: organization_id = l_org_id;
1483:
1484: IF NOT l_des_locid IS NULL