APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_OPERATION_RESOURCES

Line 128: wip_operation_resources wor

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

Line 190: from wip_operation_resources

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

Line 199: from wip_operation_resources

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

Line 686: from wip_operation_resources

682:
683: CURSOR c_cur_wor(l_wip_entity_id1 NUMBER,l_organization_id1 NUMBER,
684: l_operation_seq_num1 NUMBER ) IS --for --rhshriva
685: select resource_seq_num
686: from wip_operation_resources
687: where wip_entity_id =l_wip_entity_id1 and
688: organization_id = l_organization_id1 and
689: operation_seq_num = l_operation_seq_num1 ;
690:

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

895: l_primary_qty := round((p_transaction_qty / l_conversion_rate),6) ;
896:
897: l_stmt_num := 190;
898:
899: -- If the resource_sequence number entry does not exist in WIP_OPERATION_RESOURCES, then place a new entry
900:
901: open c_cur_wor(l_wip_entity_id1 =>l_wip_entity_id,
902: l_organization_id1=>l_organization_id,
903: l_operation_seq_num1=>l_operation_seq_num) ;

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

905: LOOP
906: fetch c_cur_wor into l_res_seq_num_temp;
907: EXIT WHEN c_cur_wor%NOTFOUND;
908:
909: -- Check whether the entry for resource_sequnece_num exists in WIP_OPERATION_RESOURCES
910:
911: if (l_res_seq_num_temp = p_resource_seq_num) then
912: old_res_status := 1;
913:

Line 917: from wip_operation_resources

913:
914: BEGIN
915: select nvl(usage_rate_or_amount,0)
916: into l_usage_rate_or_amount
917: from wip_operation_resources
918: where wip_entity_id = l_wip_entity_id
919: and operation_seq_num = l_operation_seq_num
920: and resource_seq_num = l_res_seq_num_temp
921: and organization_id = l_organization_id;

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

937: l_stmt_num := 210;
938:
939: if (old_res_status = 0) then
940:
941: -- If entry does not exists in WIP_OPERATION_RESOURCES then place a new entry into WIP_OPERATION_RESOURCES
942:
943: insert into wip_operation_resources(
944: WIP_ENTITY_ID
945: ,OPERATION_SEQ_NUM

Line 943: insert into wip_operation_resources(

939: if (old_res_status = 0) then
940:
941: -- If entry does not exists in WIP_OPERATION_RESOURCES then place a new entry into WIP_OPERATION_RESOURCES
942:
943: insert into wip_operation_resources(
944: WIP_ENTITY_ID
945: ,OPERATION_SEQ_NUM
946: ,RESOURCE_SEQ_NUM
947: ,ORGANIZATION_ID