APPS.WIP_BATCH_MOVE dependencies on WIP_OPERATIONS

Line 125: wip_operations wo1,

121: wdj.task_id task_id,
122: pjm_project.all_task_idtonum(wdj.task_id) task_number,
123: wdj.bom_revision bom_revision
124: FROM wip_discrete_jobs wdj,
125: wip_operations wo1,
126: wip_operations wo2,
127: mtl_system_items_kfv msik,
128: bom_standard_operations bso1,
129: bom_standard_operations bso2,

Line 126: wip_operations wo2,

122: pjm_project.all_task_idtonum(wdj.task_id) task_number,
123: wdj.bom_revision bom_revision
124: FROM wip_discrete_jobs wdj,
125: wip_operations wo1,
126: wip_operations wo2,
127: mtl_system_items_kfv msik,
128: bom_standard_operations bso1,
129: bom_standard_operations bso2,
130: bom_departments bd1,

Line 141: FROM wip_operations wo3

137: AND wo2.wip_entity_id = wdj.wip_entity_id
138: AND wo2.organization_id = wdj.organization_id
139: AND wo2.operation_seq_num =
140: (SELECT min(wo3.operation_seq_num)
141: FROM wip_operations wo3
142: WHERE wo3.wip_entity_id = p_wip_entity_id
143: AND wo3.organization_id = p_org_id
144: AND ((wo1.next_operation_seq_num IS NOT NULL AND
145: wo3.operation_seq_num > wo1.operation_seq_num) OR

Line 230: from wip_operations wo, bom_departments bd

226: IF(l_custom_returnStatus = 'S' and l_hook_to_op_seq is not null and l_hook_to_step_type is not null) THEN
227: --Case 1: Success and to_op_seq/step. Carry out the transaction with value provided by the hook.
228: select wo.department_id, bd.department_code
229: into l_department_id, l_department_code
230: from wip_operations wo, bom_departments bd
231: where wo.wip_entity_id = p_wip_entity_id
232: and wo.organization_id = p_org_id
233: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
234: and wo.department_id = bd.department_id;

Line 240: from wip_operations wo, bom_standard_operations bso

236:
237: BEGIN
238: select bso.operation_code
239: into l_operation_code
240: from wip_operations wo, bom_standard_operations bso
241: where wo.wip_entity_id = p_wip_entity_id
242: and wo.organization_id = p_org_id
243: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
244: and wo.standard_operation_id = bso.standard_operation_id(+);

Line 313: from wip_operations

309: wip_logger.log('l_express_cmp: '||l_express_cmp,l_return_status);
310:
311: select next_operation_seq_num
312: into l_next_op_seq_num
313: from wip_operations
314: where wip_entity_id = p_wip_entity_id
315: and organization_id = p_org_id
316: and operation_seq_num = l_move_record.to_operation_seq_num;
317:

Line 410: wip_operations wo1,

406: pjm_project.all_task_idtonum(wdj.task_id) task_number,
407: wdj.bom_revision bom_revision,
408: p_default_scrap_acct_id scrap_acct_id
409: FROM wip_discrete_jobs wdj,
410: wip_operations wo1,
411: wip_operations wo2,
412: mtl_system_items_kfv msik,
413: bom_standard_operations bso1,
414: bom_standard_operations bso2,

Line 411: wip_operations wo2,

407: wdj.bom_revision bom_revision,
408: p_default_scrap_acct_id scrap_acct_id
409: FROM wip_discrete_jobs wdj,
410: wip_operations wo1,
411: wip_operations wo2,
412: mtl_system_items_kfv msik,
413: bom_standard_operations bso1,
414: bom_standard_operations bso2,
415: bom_departments bd1,

Line 426: FROM wip_operations wo3

422: AND wo2.wip_entity_id = wdj.wip_entity_id
423: AND wo2.organization_id = wdj.organization_id
424: AND wo2.operation_seq_num =
425: (SELECT min(wo3.operation_seq_num)
426: FROM wip_operations wo3
427: WHERE wo3.wip_entity_id = p_wip_entity_id
428: AND wo3.organization_id = p_org_id
429: AND ((wo1.next_operation_seq_num IS NOT NULL AND
430: wo3.operation_seq_num > wo1.operation_seq_num) OR

Line 1568: FROM wip_operations

1564: INTO l_queue_qty,
1565: l_run_qty,
1566: l_to_move_qty,
1567: l_available_qty
1568: FROM wip_operations
1569: WHERE organization_id = p_org_id
1570: AND wip_entity_id = p_wip_entity_id
1571: AND operation_seq_num = p_op_seq;
1572: