eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on WIP_OPERATIONS

Line 31: from wip_operations wo

27:
28: cursor op_attachments(p_org_id number, p_wip_entity_id number) is
29: select wo.operation_seq_num,
30: wo.operation_sequence_id
31: from wip_operations wo
32: where wo.organization_id = p_org_id
33: and wo.wip_entity_id = p_wip_entity_id
34: and exists (select fad.pk1_value
35: from fnd_attached_documents fad

Line 96: insert into wip_operations

92: wip_logger.log('exclude ECO is: ' || l_excludeECO, l_retStatus);
93: wip_logger.log('RoutingSeqID is: ' || l_routingSeqID, l_retStatus);
94: end if;
95:
96: insert into wip_operations
97: (wip_entity_id,
98: operation_seq_num,
99: organization_id,
100: repetitive_schedule_id,

Line 227: update wip_operations wo

223: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,
224: bos.attribute14, bos.attribute15, bos.check_skill;
225:
226:
227: update wip_operations wo
228: set previous_operation_seq_num = (select max(operation_seq_num)
229: from wip_operations
230: where wip_entity_id = p_wipEntityID
231: and organization_id = p_orgID

Line 229: from wip_operations

225:
226:
227: update wip_operations wo
228: set previous_operation_seq_num = (select max(operation_seq_num)
229: from wip_operations
230: where wip_entity_id = p_wipEntityID
231: and organization_id = p_orgID
232: and operation_seq_num < wo.operation_seq_num),
233: next_operation_seq_num = (select min(operation_seq_num)

Line 234: from wip_operations

230: where wip_entity_id = p_wipEntityID
231: and organization_id = p_orgID
232: and operation_seq_num < wo.operation_seq_num),
233: next_operation_seq_num = (select min(operation_seq_num)
234: from wip_operations
235: where wip_entity_id = p_wipEntityID
236: and organization_id = p_orgID
237: and operation_seq_num > wo.operation_seq_num)
238: where wo.wip_entity_id = p_wipEntityID

Line 479: wip_operations wo

475: bsor.attribute14,
476: bsor.attribute15
477: from bom_resources br,
478: bom_sub_operation_resources bsor,
479: wip_operations wo
480: where wo.organization_id = p_orgID
481: and wo.wip_entity_id = p_wipEntityID
482: and wo.operation_sequence_id = bsor.operation_sequence_id
483: and bsor.resource_id = br.resource_id

Line 529: WIP_OPERATIONS WO,

525: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
526: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
527: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
528: FROM BOM_OPERATION_SKILLS BOS,
529: WIP_OPERATIONS WO,
530: WIP_ENTITIES WE
531: WHERE
532: WE.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
533: AND WO.ORGANIZATION_ID = WO.ORGANIZATION_ID

Line 699: from wip_operations

695:
696: begin
697: select nvl(min(operation_seq_num), 1)
698: into l_minOp
699: from wip_operations
700: where wip_entity_id = p_wipEntityID;
701: exception
702: when others then
703: l_minOp := 1;

Line 713: from wip_operations

709: -- routing to create the job so the op exploded might not exists. In that case, we will assign this component
710: -- to the first operation
711: begin
712: select 1 into l_exists
713: from wip_operations
714: where wip_entity_id = p_wipEntityID
715: and operation_seq_num = l_compTbl(l_count).operation_seq_num;
716: l_opSeq := l_compTbl(l_count).operation_seq_num;
717: exception

Line 897: from wip_operations wo

893: decode(nvl(max(wo.count_point_type), 0),
894: wip_constants.no_manual, wip_constants.op_pull,
895: wro.wip_supply_type),
896: wro.wip_supply_type)
897: from wip_operations wo
898: where wo.organization_id = wro.organization_id
899: and wo.wip_entity_id = wro.wip_entity_id
900: and nvl(wo.repetitive_schedule_id, -1) = nvl(wro.repetitive_schedule_id, -1)
901: and wo.operation_seq_num = abs(wro.operation_seq_num)),

Line 1074: from wip_operations

1070:
1071: if ( l_jobStatus <> wip_constants.unreleased ) then
1072: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
1073: into l_minOp
1074: from wip_operations
1075: where organization_id = p_orgID
1076: and wip_entity_id = p_wipEntityID;
1077:
1078: if ( l_minOp = fnd_api.g_miss_num ) then

Line 1088: update wip_operations

1084: end if;
1085: return;
1086: end if;
1087:
1088: update wip_operations
1089: set quantity_in_queue = quantity_in_queue - (scheduled_quantity - p_qty)
1090: where organization_id = p_orgID
1091: and wip_entity_id = p_wipEntityID
1092: and operation_seq_num = l_minOp

Line 1096: update wip_operations

1092: and operation_seq_num = l_minOp
1093: and quantity_in_queue <> 0 ;/* Fix for Bug 6639146 */
1094:
1095: /* Fix for bug 6954115 */
1096: update wip_operations
1097: set quantity_in_queue = p_qty -(quantity_completed+quantity_running+quantity_in_queue)
1098: where organization_id = p_orgID
1099: and wip_entity_id = p_wipEntityID
1100: and operation_seq_num = l_minOp

Line 1106: update wip_operations

1102: and (quantity_completed+quantity_running+quantity_in_queue) < p_qty;
1103:
1104: end if;
1105:
1106: update wip_operations
1107: set scheduled_quantity = p_qty
1108: where organization_id = p_orgID
1109: and wip_entity_id = p_wipEntityID;
1110: