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 299: wip_operations wo1,

295: pjm_project.all_task_idtonum(wdj.task_id) task_number,
296: wdj.bom_revision bom_revision,
297: p_default_scrap_acct_id scrap_acct_id
298: FROM wip_discrete_jobs wdj,
299: wip_operations wo1,
300: wip_operations wo2,
301: mtl_system_items_kfv msik,
302: bom_standard_operations bso1,
303: bom_standard_operations bso2,

Line 300: wip_operations wo2,

296: wdj.bom_revision bom_revision,
297: p_default_scrap_acct_id scrap_acct_id
298: FROM wip_discrete_jobs wdj,
299: wip_operations wo1,
300: wip_operations wo2,
301: mtl_system_items_kfv msik,
302: bom_standard_operations bso1,
303: bom_standard_operations bso2,
304: bom_departments bd1,

Line 315: FROM wip_operations wo3

311: AND wo2.wip_entity_id = wdj.wip_entity_id
312: AND wo2.organization_id = wdj.organization_id
313: AND wo2.operation_seq_num =
314: (SELECT min(wo3.operation_seq_num)
315: FROM wip_operations wo3
316: WHERE wo3.wip_entity_id = p_wip_entity_id
317: AND wo3.organization_id = p_org_id
318: AND ((wo1.next_operation_seq_num IS NOT NULL AND
319: wo3.operation_seq_num > wo1.operation_seq_num) OR

Line 1382: FROM wip_operations

1378: INTO l_queue_qty,
1379: l_run_qty,
1380: l_to_move_qty,
1381: l_available_qty
1382: FROM wip_operations
1383: WHERE organization_id = p_org_id
1384: AND wip_entity_id = p_wip_entity_id
1385: AND operation_seq_num = p_op_seq;
1386: