APPS.CSI_WIP_TRXS_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1093: FROM wip_requirement_operations

1089: api_log('get_qty_per_assembly');
1090:
1091: SELECT sum(nvl(quantity_per_assembly,0))
1092: INTO l_qty_per_assy
1093: FROM wip_requirement_operations
1094: WHERE organization_id = p_organization_id
1095: AND wip_entity_id = p_wip_entity_id
1096: AND inventory_item_id = p_component_item_id;
1097:

Line 1121: FROM wip_requirement_operations wip, mtl_system_items msi

1117: SELECT wip.inventory_item_id,
1118: sum(required_quantity) qty_required,
1119: sum(quantity_issued) qty_issued,
1120: nvl(sum(nvl(quantity_per_assembly,0)),0) qty_per_assy
1121: FROM wip_requirement_operations wip, mtl_system_items msi
1122: WHERE wip.wip_entity_id = p_wip_entity_id
1123: AND wip.organization_id = p_organization_id
1124: AND wip.inventory_item_id <> p_assembly_item_id
1125: AND wip.inventory_item_id = msi.inventory_item_id

Line 1143: FROM wip_requirement_operations wip, mtl_system_items msi

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

Line 3327: FROM wip_requirement_operations

3323:
3324: -- get the total quantity issued from the requirements
3325: SELECT sum(nvl(quantity_issued,0))
3326: INTO l_total_qty_issued
3327: FROM wip_requirement_operations
3328: WHERE wip_entity_id = p_txn_ref.wip_entity_id
3329: AND organization_id = p_txn_ref.organization_id
3330: AND inventory_item_id = p_txn_ref.inventory_item_id;
3331: