APPS.WSMPUTIL dependencies on WIP_OPERATIONS

Line 3060: FROM WIP_OPERATIONS

3056: -- ED: CZH.I_9999
3057:
3058: SELECT OPERATION_SEQUENCE_ID
3059: INTO l_wo_op_seq_id
3060: FROM WIP_OPERATIONS
3061: WHERE ORGANIZATION_ID = p_organization_id
3062: AND wip_entity_id = p_wip_entity_id
3063: AND OPERATION_SEQ_NUM = p_wo_op_seq_num;
3064:

Line 3184: FROM WIP_OPERATIONS

3180:
3181: -- At outside routing operation
3182: SELECT OPERATION_SEQUENCE_ID
3183: INTO l_op_seq_id
3184: FROM WIP_OPERATIONS
3185: WHERE ORGANIZATION_ID = p_organization_id
3186: AND wip_entity_id = p_wip_entity_id
3187: AND OPERATION_SEQ_NUM = p_wo_op_seq_num;
3188: IF(NVL(l_op_seq_id, -1) = -1) THEN

Line 3338: from wip_operations

3334: --and BIC not match, thus it was incorrectly be treated as manually added comp.
3335: l_stmt_num := 15;
3336: select min(operation_seq_num)
3337: into l_first_op_seq_num
3338: from wip_operations
3339: where wip_entity_id = p_wip_entity_id;
3340: --EA: 3546334
3341:
3342:

Line 3354: From BOM_OPERATION_SEQUENCES bos, wip_operations wo

3350: Begin
3351:
3352: Select bos.operation_seq_num, wo.quantity_waiting_to_move
3353: into l_rtg_op_seq_num, l_qty_at_tomove
3354: From BOM_OPERATION_SEQUENCES bos, wip_operations wo
3355: Where bos.operation_sequence_id = NVL(wo.operation_sequence_id, -999)
3356: and wo.wip_entity_id = p_wip_entity_id
3357: and wo.operation_seq_num = p_op_seq_num
3358: and wo.organization_id = p_organization_id

Line 3463: FROM wip_operations

3459:
3460: --2. Get the opseqid of the current operation of the job
3461: SELECT operation_sequence_id
3462: INTO l_job_start_op_seq_id
3463: FROM wip_operations
3464: WHERE wip_entity_id = p_wip_entity_id
3465: AND organization_id = p_organization_id
3466: AND operation_seq_num = p_op_seq_num;
3467:

Line 3782: From bom_operation_resources bor, wip_operations wo

3778: and wor.operation_seq_num = p_op_seq_num
3779: and wor.repetitive_schedule_id is NULL
3780: and wor.applied_resource_units <> 0
3781: and NOT EXISTS (select 1
3782: From bom_operation_resources bor, wip_operations wo
3783: Where bor.operation_sequence_id = wo.operation_sequence_id
3784: and bor.resource_seq_num = wor.resource_seq_num
3785: and wo.wip_entity_id = wor.wip_entity_id
3786: and wo.operation_seq_num = wor.operation_seq_num);

Line 5549: , wip_operations wo

5545: Select 1 into l_count
5546: From dual
5547: Where Exists ( Select 'Jobs with Qty At this Operation Exists'
5548: from wip_discrete_jobs wdj
5549: , wip_operations wo
5550: Where wdj.wip_entity_id = wo.wip_entity_id
5551: and NVL(wo.operation_sequence_id, -99999) =
5552: WSMPUTIL.replacement_op_seq_id (p_operation_sequence_id
5553: , wdj.routing_revision_date)

Line 5611: , wip_operations wo

5607: Where Exists (
5608: Select 'Jobs with Qty At this Operation Exists'
5609: from bom_operation_sequences bos
5610: , wip_discrete_jobs wdj
5611: , wip_operations wo
5612: Where wdj.common_routing_sequence_id = p_routing_sequence_id
5613: and wdj.status_type = WIP_CONSTANTS.RELEASED
5614: and bos.routing_sequence_id = wdj.common_routing_sequence_id
5615: and bos.operation_seq_num = p_operation_seq_num

Line 5961: wip_operations wo

5957:
5958: SELECT distinct(wco.operation_sequence_id) -- Added distinct to fix bug #3507878
5959: INTO l_copy_op_seq_id
5960: FROM wsm_copy_operations wco,
5961: wip_operations wo
5962: WHERE wo.operation_sequence_id = p_job_op_seq_id
5963: AND wo.wip_entity_id = p_wip_entity_id
5964: AND wo.wip_entity_id = wco.wip_entity_id
5965: AND wo.wsm_op_seq_num = wco.operation_seq_num;