APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_OPERATION_RESOURCES

Line 127: wip_operation_resources wor

123: br.resource_code,
124: br.resource_id
125: from cst_activities ca,
126: bom_resources br,
127: wip_operation_resources wor
128: where wor.repetitive_schedule_id is null
129: and br.organization_id = wor.organization_id
130: and wor.resource_id = br.resource_id
131: and wor.activity_id = ca.activity_id (+)

Line 194: from wip_operation_resources

190:
191: -- Cursor to fetch if resource seq num corresponding to resource_id.
192: CURSOR c_resource_seq_num IS
193: select resource_seq_num
194: from wip_operation_resources
195: where wip_entity_id = p_wip_entity_id
196: and operation_seq_num = p_operation_seq_num
197: and organization_id = p_organization_id
198: and resource_id = l_resource_id;

Line 203: from wip_operation_resources

199:
200: -- Cursor to fetch maximum resource sequence number attached to operation.
201: CURSOR c_cur_resource_seq_num IS
202: select resource_seq_num
203: from wip_operation_resources
204: where wip_entity_id = p_wip_entity_id
205: and operation_seq_num = p_operation_seq_num
206: and organization_id = p_organization_id
207: order by resource_seq_num desc;

Line 654: from wip_operation_resources

650:
651: CURSOR c_cur_wor(l_wip_entity_id1 NUMBER,l_organization_id1 NUMBER,
652: l_operation_seq_num1 NUMBER ) IS --for --rhshriva
653: select resource_seq_num
654: from wip_operation_resources
655: where wip_entity_id =l_wip_entity_id1 and
656: organization_id = l_organization_id1 and
657: operation_seq_num = l_operation_seq_num1 ;
658:

Line 832: -- If the resource_sequence number entry does not exist in WIP_OPERATION_RESOURCES, then place a new entry

828: l_primary_qty := round((p_transaction_qty / l_conversion_rate),6) ;
829:
830: l_stmt_num := 190;
831:
832: -- If the resource_sequence number entry does not exist in WIP_OPERATION_RESOURCES, then place a new entry
833:
834: open c_cur_wor(l_wip_entity_id1 =>l_wip_entity_id,
835: l_organization_id1=>l_organization_id,
836: l_operation_seq_num1=>l_operation_seq_num) ;

Line 842: -- Check whether the entry for resource_sequnece_num exists in WIP_OPERATION_RESOURCES

838: LOOP
839: fetch c_cur_wor into l_res_seq_num_temp;
840: EXIT WHEN c_cur_wor%NOTFOUND;
841:
842: -- Check whether the entry for resource_sequnece_num exists in WIP_OPERATION_RESOURCES
843:
844: if (l_res_seq_num_temp = p_resource_seq_num) then
845: old_res_status := 1;
846:

Line 850: from wip_operation_resources

846:
847: BEGIN
848: select nvl(usage_rate_or_amount,0)
849: into l_usage_rate_or_amount
850: from wip_operation_resources
851: where wip_entity_id = l_wip_entity_id
852: and operation_seq_num = l_operation_seq_num
853: and resource_seq_num = l_res_seq_num_temp
854: and organization_id = l_organization_id;

Line 874: -- If entry does not exists in WIP_OPERATION_RESOURCES then place a new entry into WIP_OPERATION_RESOURCES

870: l_stmt_num := 210;
871:
872: if (old_res_status = 0) then
873:
874: -- If entry does not exists in WIP_OPERATION_RESOURCES then place a new entry into WIP_OPERATION_RESOURCES
875:
876: insert into wip_operation_resources(
877: WIP_ENTITY_ID
878: ,OPERATION_SEQ_NUM

Line 876: insert into wip_operation_resources(

872: if (old_res_status = 0) then
873:
874: -- If entry does not exists in WIP_OPERATION_RESOURCES then place a new entry into WIP_OPERATION_RESOURCES
875:
876: insert into wip_operation_resources(
877: WIP_ENTITY_ID
878: ,OPERATION_SEQ_NUM
879: ,RESOURCE_SEQ_NUM
880: ,ORGANIZATION_ID