APPS.WSMPLBJI dependencies on WIP_OPERATION_YIELDS

Line 1908: INSERT INTO WIP_OPERATION_YIELDS

1904: end if;
1905:
1906: l_stat_num := 60;
1907: -- The below insert is used for Costing Changes (OP Yield)
1908: INSERT INTO WIP_OPERATION_YIELDS
1909: (WIP_ENTITY_ID,
1910: OPERATION_SEQ_NUM,
1911: ORGANIZATION_ID,
1912: LAST_UPDATE_DATE,

Line 1943: FROM WIP_OPERATION_YIELDS WOY

1939: FROM WIP_OPERATIONS WO
1940: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1941: AND WO.OPERATION_SEQUENCE_ID = p_seq_id
1942: AND WO.OPERATION_SEQ_NUM NOT IN (SELECT WOY.OPERATION_SEQ_NUM
1943: FROM WIP_OPERATION_YIELDS WOY
1944: WHERE WOY.WIP_ENTITY_ID = p_wip_entity_id);
1945:
1946: if lbji_debug = 'Y' then
1947: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into woy');

Line 5596: delete from wip_operation_yields where wip_entity_id = v_wlji_wip_entity_id(v_index);

5592: l_stmt_num := 700.2;
5593: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5594: delete from wip_operation_resources where wip_entity_id = v_wlji_wip_entity_id(v_index);
5595: delete from wip_requirement_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5596: delete from wip_operation_yields where wip_entity_id = v_wlji_wip_entity_id(v_index);
5597:
5598: l_stmt_num := 700.3;
5599: -- Now validate the alternate designators to get the routing and bom sequence id.
5600: -- Also get the completion subinventory and locator. If the user has provided them

Line 6083: delete from wip_operation_yields

6079: if p_change_routing_reference = 1 OR p_change_bom_reference = 1 then
6080: begin
6081: delete from wip_operations
6082: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6083: delete from wip_operation_yields
6084: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6085: delete from wip_operation_resources
6086: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6087: delete from wip_requirement_operations

Line 6988: UPDATE WIP_OPERATION_YIELDS WOY

6984: l_error_count := l_error_count + 1;
6985: GOTO skip_other_steps;
6986: end if;
6987:
6988: UPDATE WIP_OPERATION_YIELDS WOY
6989: SET SCRAP_ACCOUNT = nvl(l_scrap_account10, WOY.SCRAP_ACCOUNT),
6990: EST_SCRAP_ABSORB_ACCOUNT = nvl(l_est_scrap_abs_account10, WOY.EST_SCRAP_ABSORB_ACCOUNT)
6991: WHERE WIP_ENTITY_ID = v_wlji_wip_entity_id(v_index)
6992: and operation_seq_num = min_op_seq_num;

Line 7023: UPDATE WIP_OPERATION_YIELDS WOY

7019: l_error_count := l_error_count + 1;
7020: GOTO skip_other_steps;
7021: end if;
7022:
7023: UPDATE WIP_OPERATION_YIELDS WOY
7024: SET SCRAP_ACCOUNT = nvl(l_scrap_account9999, WOY.SCRAP_ACCOUNT),
7025: EST_SCRAP_ABSORB_ACCOUNT = nvl(l_est_scrap_abs_account9999, WOY.EST_SCRAP_ABSORB_ACCOUNT)
7026: WHERE WIP_ENTITY_ID = v_wlji_wip_entity_id(v_index)
7027: and operation_seq_num = max_op_seq_num;