APPS.WSMPLBJI dependencies on WIP_REQUIREMENT_OPERATIONS

Line 867: update wip_requirement_operations

863: from wip_parameters
864: where organization_id = p_org;*/
865:
866: --IF (nvl(l_include_comp_yld, 1) = 1) THEN -- Include Component Yield
867: update wip_requirement_operations
868: --set quantity_issued = required_quantity
869: set quantity_issued = 0
870: ,required_quantity = 0
871: where wip_entity_id = p_wip_entity_id

Line 878: update wip_requirement_operations

874: --set to 0 irrespective of supply type as these fields are not used by costing now.
875: --and wip_supply_type not in (2, 4, 5, 6); -- Fix for bug #2685463
876:
877: /*ELSIF (nvl(l_include_comp_yld, 1) = 2) THEN -- DO NOT Include Component Yield
878: update wip_requirement_operations
879: set quantity_issued = round(quantity_per_assembly * decode(nvl(basis_type,1), 2, 1, p_start_quantity), 6)
880: where wip_entity_id = p_wip_entity_id
881: and operation_seq_num < abb_op_seq_num
882: and wip_supply_type not in (2, 4, 5, 6); -- Fix for bug #2685463

Line 2139: FROM WIP_REQUIREMENT_OPERATIONS

2135: OR WPB.PL_RESOURCE_OUT <> 0
2136: OR WPB.PL_OVERHEAD_OUT <> 0
2137: OR WPB.PL_OUTSIDE_PROCESSING_OUT <> 0
2138: OR EXISTS (SELECT 'X'
2139: FROM WIP_REQUIREMENT_OPERATIONS
2140: WHERE ORGANIZATION_ID = p_organization_id
2141: AND WIP_ENTITY_ID = p_wip_entity_id
2142: AND QUANTITY_ISSUED <> 0)
2143: OR EXISTS (SELECT 'X'

Line 5589: delete from wip_requirement_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);

5585:
5586: l_stmt_num := 700.2;
5587: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5588: delete from wip_operation_resources where wip_entity_id = v_wlji_wip_entity_id(v_index);
5589: delete from wip_requirement_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5590: delete from wip_operation_yields where wip_entity_id = v_wlji_wip_entity_id(v_index);
5591:
5592: l_stmt_num := 700.3;
5593: -- Now validate the alternate designators to get the routing and bom sequence id.

Line 6081: delete from wip_requirement_operations

6077: delete from wip_operation_yields
6078: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6079: delete from wip_operation_resources
6080: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6081: delete from wip_requirement_operations
6082: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6083: exception
6084: when others then
6085: rollback;

Line 6924: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

6920: end if;
6921:
6922: l_stmt_num := 1064;
6923: --LBM enh: modified the expression on required_quantity
6924: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
6925: SET WRO.DATE_REQUIRED =
6926: (SELECT NVL(MIN(FIRST_UNIT_START_DATE), v_wlji_fusd(v_index))
6927: FROM WIP_OPERATIONS
6928: WHERE ORGANIZATION_ID = v_wlji_org(v_index)

Line 7409: UPDATE WIP_REQUIREMENT_OPERATIONS

7405: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into mtlt');
7406: end if;
7407:
7408: l_stmt_num := 1160;
7409: UPDATE WIP_REQUIREMENT_OPERATIONS
7410: set wip_supply_type = 1
7411: where wip_entity_id = v_wlji_wip_entity_id(v_index)
7412: and operation_seq_num = 10
7413: and inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id;