APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on MTL_SYSTEM_ITEMS

Line 87: from wip_entities we, mtl_system_items msi

83: -- If it's discrete, and does not have a default lot then can't move_complete/return
84: -- if it's repetitive then can't move_complete/return_move
85:
86: select count(*) into x_valid_ez_complete
87: from wip_entities we, mtl_system_items msi
88: where we.wip_entity_id = p_wip_entity_id
89: and we.organization_id = p_org_id
90: and msi.inventory_item_id = we.primary_item_id
91: and msi.organization_id = we.organization_id

Line 112: from MTL_SYSTEM_ITEMS msi, WIP_ENTITIES we

108: x_valid_ez_complete OUT NOCOPY NUMBER) IS
109: BEGIN
110:
111: select count(*) into x_valid_ez_complete
112: from MTL_SYSTEM_ITEMS msi, WIP_ENTITIES we
113: where we.organization_id = p_org_id
114: and we.wip_entity_id = p_wip_entity_id
115: and msi.inventory_item_id = we.primary_item_id
116: and msi.organization_id = we.organization_id

Line 170: from MTL_SYSTEM_ITEMS msi

166: where we.wip_entity_id = p_wip_entity_id
167: and we.organization_id = p_org_id
168: and exists (
169: select 'X'
170: from MTL_SYSTEM_ITEMS msi
171: where msi.organization_id = p_org_id
172: and msi.inventory_item_id = we.primary_item_id
173: and msi.revision_qty_control_code=2)
174: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE

Line 292: from mtl_system_items msi, wip_entities we

288:
289: begin
290: select msi.lot_control_code, msi.shelf_life_code
291: into l_lot_control_code, l_shelf_life_code
292: from mtl_system_items msi, wip_entities we
293: where we.wip_entity_id = p_wip_entity_id
294: and we.organization_id = p_org_id
295: and msi.organization_id = we.organization_id
296: and INVENTORY_ITEM_ID = we.primary_item_id;

Line 392: mtl_system_items msi,

388: (rti.primary_quantity/g_OSP_rec.usage_rate_or_amount)))
389: INTO
390: l_primary_quantity
391: FROM
392: mtl_system_items msi,
393: rcv_transactions_interface rti
394: WHERE rti.interface_transaction_id = g_OSP_rec.source_line_id
395: AND msi.inventory_item_id = rti.item_id
396: AND msi.organization_id = g_OSP_rec.organization_id;

Line 1246: from mtl_system_items msi

1242: decode (nvl(l_usage_rate_or_amount, 0) ,
1243: 0, 0,
1244: l_total_po_qty_delivered/l_usage_rate_or_amount))
1245: into l_total_pri_qty_delivered
1246: from mtl_system_items msi
1247: where msi.inventory_item_id = l_osp_item_id
1248: and msi.organization_id = g_ShopFloorMove_rec.organization_id;
1249: exception
1250: when others then

Line 1511: FROM mtl_system_items

1507: AND g_ShopFloorMove_rec.organization_id IS NOT NULL THEN
1508:
1509: SELECT primary_uom_code
1510: INTO l_primary_uom
1511: FROM mtl_system_items
1512: WHERE inventory_item_id = g_ShopFloorMove_rec.primary_item_id
1513: AND organization_id = g_ShopFloorMove_rec.organization_id;
1514:
1515: RETURN l_primary_uom;