DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 4361: FROM wip_requirement_operations wip,

4357: SELECT wip.inventory_item_id,
4358: sum(required_quantity) qty_required,
4359: sum(quantity_issued) qty_issued,
4360: sum(quantity_per_assembly) qty_per_assy
4361: FROM wip_requirement_operations wip,
4362: mtl_system_items msi
4363: WHERE wip_entity_id = p_wip_entity_id
4364: AND wip.organization_id = p_organization_id
4365: AND wip.inventory_item_id = msi.inventory_item_id