APPS.CSI_WIP_TRXS_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1113: FROM wip_requirement_operations

1109: api_log('get_qty_per_assembly');
1110:
1111: SELECT sum(nvl(quantity_per_assembly,0))
1112: INTO l_qty_per_assy
1113: FROM wip_requirement_operations
1114: WHERE organization_id = p_organization_id
1115: AND wip_entity_id = p_wip_entity_id
1116: AND inventory_item_id = p_component_item_id;
1117:

Line 1141: FROM wip_requirement_operations wip, mtl_system_items msi

1137: SELECT wip.inventory_item_id,
1138: sum(required_quantity) qty_required,
1139: sum(quantity_issued) qty_issued,
1140: nvl(sum(nvl(quantity_per_assembly,0)),0) qty_per_assy
1141: FROM wip_requirement_operations wip, mtl_system_items msi
1142: WHERE wip.wip_entity_id = p_wip_entity_id
1143: AND wip.organization_id = p_organization_id
1144: AND wip.inventory_item_id <> p_assembly_item_id
1145: AND wip.inventory_item_id = msi.inventory_item_id

Line 1163: FROM wip_requirement_operations wip, mtl_system_items msi

1159: SELECT wip.inventory_item_id,
1160: sum(required_quantity) qty_required,
1161: sum(quantity_issued) qty_issued,
1162: nvl(sum(nvl(quantity_per_assembly,0)),0) qty_per_assy
1163: FROM wip_requirement_operations wip, mtl_system_items msi
1164: WHERE wip.wip_entity_id = p_wip_entity_id
1165: AND wip.organization_id = p_organization_id
1166: AND wip.inventory_item_id <> p_assembly_item_id
1167: AND wip.inventory_item_id = msi.inventory_item_id

Line 3456: FROM wip_requirement_operations

3452:
3453: -- get the total quantity issued from the requirements
3454: SELECT sum(nvl(quantity_issued,0))
3455: INTO l_total_qty_issued
3456: FROM wip_requirement_operations
3457: WHERE wip_entity_id = p_txn_ref.wip_entity_id
3458: AND organization_id = p_txn_ref.organization_id
3459: AND inventory_item_id = p_txn_ref.inventory_item_id;
3460: