DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WIP_OPERATION_RESOURCES

Line 3776: From wip_operation_resources wor

3772: BEGIN
3773: -- added by BBK.
3774:
3775: select 1 into p_manually_added_resource
3776: From wip_operation_resources wor
3777: Where wor.wip_entity_id = p_wip_entity_id
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

Line 4614: from wip_operation_resources wor

4610: l_op_seq_num := -1 ;
4611:
4612: select unique wor.operation_seq_num
4613: into l_op_seq_num
4614: from wip_operation_resources wor
4615: where wor.organization_id = p_organization_id
4616: and wor.wip_entity_id = p_wip_entity_id
4617: and wor.operation_seq_num = nvl(p_operation_seq_num,wor.operation_seq_num)
4618: and wor.autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT,