DBA Data[Home] [Help]

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 356: mtl_system_items msi,

352: (rti.primary_quantity/g_OSP_rec.usage_rate_or_amount)))
353: INTO
354: l_primary_quantity
355: FROM
356: mtl_system_items msi,
357: rcv_transactions_interface rti
358: WHERE rti.interface_transaction_id = g_OSP_rec.source_line_id
359: AND msi.inventory_item_id = rti.item_id
360: AND msi.organization_id = g_OSP_rec.organization_id;

Line 1200: from mtl_system_items msi

1196: decode (nvl(l_usage_rate_or_amount, 0) ,
1197: 0, 0,
1198: l_total_po_qty_delivered/l_usage_rate_or_amount))
1199: into l_total_pri_qty_delivered
1200: from mtl_system_items msi
1201: where msi.inventory_item_id = l_osp_item_id
1202: and msi.organization_id = g_ShopFloorMove_rec.organization_id;
1203: exception
1204: when others then

Line 1452: FROM mtl_system_items

1448: AND g_ShopFloorMove_rec.organization_id IS NOT NULL THEN
1449:
1450: SELECT primary_uom_code
1451: INTO l_primary_uom
1452: FROM mtl_system_items
1453: WHERE inventory_item_id = g_ShopFloorMove_rec.primary_item_id
1454: AND organization_id = g_ShopFloorMove_rec.organization_id;
1455:
1456: RETURN l_primary_uom;