eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_COPY_ROUTING dependencies on STANDARD

Line 47: from bom_standard_operations

43: p_op_type number) Return Boolean Is
44: l_total number := 0;
45: Begin
46: select count(*) into l_total
47: from bom_standard_operations
48: where organization_id = p_org_id
49: and line_id = p_line_id
50: and operation_code = p_std_op_code
51: and operation_type = p_op_type;

Line 235: and p_lineop_code = bosv.standard_operation_code

231: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
232: and (p_lineop_code is NULL or exists (
233: select 1 from bom_operation_sequences_v bosv
234: where bosv.routing_sequence_id = bor.common_routing_sequence_id
235: and p_lineop_code = bosv.standard_operation_code
236: and bosv.operation_type = 3)
237: )
238: and (p_process_code is NULL or exists (
239: select 1 from bom_operation_sequences_v bosv

Line 241: and p_process_code = bosv.standard_operation_code

237: )
238: and (p_process_code is NULL or exists (
239: select 1 from bom_operation_sequences_v bosv
240: where bosv.routing_sequence_id = bor.common_routing_sequence_id
241: and p_process_code = bosv.standard_operation_code
242: and bosv.operation_type = 2)
243: )
244: Order by
245: bor.routing_sequence_id

Line 273: from bom_operation_sequences bos1, bom_standard_operations bso1

269: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
270: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
271: and (p_lineop_code is NULL or exists (
272: select 1
273: from bom_operation_sequences bos1, bom_standard_operations bso1
274: where bos1.routing_sequence_id = bor.common_routing_sequence_id
275: and p_lineop_code = bso1.operation_code
276: and bos1.standard_operation_id = bso1.standard_operation_id
277: and bso1.organization_id = p_organization_id

Line 276: and bos1.standard_operation_id = bso1.standard_operation_id

272: select 1
273: from bom_operation_sequences bos1, bom_standard_operations bso1
274: where bos1.routing_sequence_id = bor.common_routing_sequence_id
275: and p_lineop_code = bso1.operation_code
276: and bos1.standard_operation_id = bso1.standard_operation_id
277: and bso1.organization_id = p_organization_id
278: and bso1.line_id = p_line_id_from
279: and bos1.operation_type = 3)
280: )

Line 283: from bom_operation_sequences bos1, bom_standard_operations bso1

279: and bos1.operation_type = 3)
280: )
281: and (p_process_code is NULL or exists (
282: select 1
283: from bom_operation_sequences bos1, bom_standard_operations bso1
284: where bos1.routing_sequence_id = bor.common_routing_sequence_id
285: and p_process_code = bso1.operation_code
286: and bos1.standard_operation_id = bso1.standard_operation_id
287: and bso1.organization_id = p_organization_id

Line 286: and bos1.standard_operation_id = bso1.standard_operation_id

282: select 1
283: from bom_operation_sequences bos1, bom_standard_operations bso1
284: where bos1.routing_sequence_id = bor.common_routing_sequence_id
285: and p_process_code = bso1.operation_code
286: and bos1.standard_operation_id = bso1.standard_operation_id
287: and bso1.organization_id = p_organization_id
288: and bso1.line_id = p_line_id_from
289: and bos1.operation_type = 2)
290: )

Line 395: ,bosv.standard_operation_code Standard_Operation_Code

391: ,bosv.operation_type Operation_Type
392: ,bosv.effectivity_date Start_Effective_Date
393: ,bosv.operation_seq_num New_Operation_Sequence_Number
394: ,bosv.effectivity_date New_Start_Effective_Date
395: ,bosv.standard_operation_code Standard_Operation_Code
396: ,bosv.department_code Department_Code
397: ,bosv.operation_lead_time_percent Op_Lead_Time_Percent
398: ,bosv.minimum_transfer_quantity Minimum_Transfer_Quantity
399: ,bosv.count_point_type Count_Point_Type

Line 508: standard_operation_id

504:
505:
506: Cursor c_std_ops(p_routing_sequence_id number) Is
507: Select distinct
508: standard_operation_id
509: ,standard_operation_code
510: ,operation_type
511: From
512: bom_operation_sequences_v bosv

Line 509: ,standard_operation_code

505:
506: Cursor c_std_ops(p_routing_sequence_id number) Is
507: Select distinct
508: standard_operation_id
509: ,standard_operation_code
510: ,operation_type
511: From
512: bom_operation_sequences_v bosv
513: Where

Line 518: standard_operation_code

514: routing_sequence_id = p_routing_sequence_id
515: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)
516: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
517: Order by
518: standard_operation_code
519: ;
520:
521:
522: Cursor c_std_op(p_standard_operation_id number) Is

Line 522: Cursor c_std_op(p_standard_operation_id number) Is

518: standard_operation_code
519: ;
520:
521:
522: Cursor c_std_op(p_standard_operation_id number) Is
523: Select
524: *
525: From
526: bom_standard_operations

Line 526: bom_standard_operations

522: Cursor c_std_op(p_standard_operation_id number) Is
523: Select
524: *
525: From
526: bom_standard_operations
527: Where
528: standard_operation_id = p_standard_operation_id
529: ;
530:

Line 528: standard_operation_id = p_standard_operation_id

524: *
525: From
526: bom_standard_operations
527: Where
528: standard_operation_id = p_standard_operation_id
529: ;
530:
531:
532: Cursor c_std_op_res(p_standard_operation_id number) Is

Line 532: Cursor c_std_op_res(p_standard_operation_id number) Is

528: standard_operation_id = p_standard_operation_id
529: ;
530:
531:
532: Cursor c_std_op_res(p_standard_operation_id number) Is
533: Select
534: *
535: From
536: bom_std_op_resources

Line 538: standard_operation_id = p_standard_operation_id

534: *
535: From
536: bom_std_op_resources
537: Where
538: standard_operation_id = p_standard_operation_id
539: ;
540:
541: Cursor c_new_rtg_seq_id(p_item_id number, p_org_id number, p_alternate varchar2) Is
542: Select

Line 721: -- copy standard operations and their resources

717: l_rtg_revision_tbl := t_rtg_revision_tbl;
718: o_rtg_revision_tbl := l_rtg_revision_tbl;
719:
720:
721: -- copy standard operations and their resources
722: SAVEPOINT copy_std;
723: l_2_ids := t_2_ids;
724: l_2_seq_ids := t_2_ids;
725: FOR stdop in c_std_ops(l_rtg_tbl(i).routing_sequence_id) LOOP

Line 730: stdop.standard_operation_code,

726: -- insert std_op for p_line_id_to
727: -- cp std_op_res from old_op_id to new_op_id
728:
729: if (not std_op_exists( p_organization_id, p_line_id_to,
730: stdop.standard_operation_code,
731: stdop.operation_type)) then
732: l_std_op_exist := true;
733: OPEN c_std_op(stdop.standard_operation_id);
734: FETCH c_std_op into std_op_rec;

Line 733: OPEN c_std_op(stdop.standard_operation_id);

729: if (not std_op_exists( p_organization_id, p_line_id_to,
730: stdop.standard_operation_code,
731: stdop.operation_type)) then
732: l_std_op_exist := true;
733: OPEN c_std_op(stdop.standard_operation_id);
734: FETCH c_std_op into std_op_rec;
735: IF c_std_op%NOTFOUND THEN
736: l_std_op_exist := false;
737: END IF;

Line 744: ,x_standard_operation_id =>new_std_op_id

740: if (l_std_op_exist) then
741: new_row_id := NULL;
742: new_std_op_id := NULL;
743: b_std_op_pkg.Insert_Row( x_rowid =>new_row_id
744: ,x_standard_operation_id =>new_std_op_id
745: ,x_operation_code =>std_op_rec.operation_code
746: ,x_operation_type =>std_op_rec.operation_type
747: ,x_line_id =>p_line_id_to
748: ,x_sequence_num =>std_op_rec.sequence_num

Line 781: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;

777: ,x_wms_task_type =>std_op_rec.wms_task_type
778: ,x_yield =>std_op_rec.yield
779: ,x_operation_yield_enabled =>std_op_rec.operation_yield_enabled);
780:
781: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;
782: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;
783:
784: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id) LOOP
785: new_row_id := null;

Line 782: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;

778: ,x_yield =>std_op_rec.yield
779: ,x_operation_yield_enabled =>std_op_rec.operation_yield_enabled);
780:
781: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;
782: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;
783:
784: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id) LOOP
785: new_row_id := null;
786: b_std_op_res_pkg.Insert_Row( x_rowid =>new_row_id

Line 784: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id) LOOP

780:
781: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;
782: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;
783:
784: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id) LOOP
785: new_row_id := null;
786: b_std_op_res_pkg.Insert_Row( x_rowid =>new_row_id
787: ,x_standard_operation_id =>new_std_op_id
788: ,x_resource_id =>std_op_res_rec.resource_id

Line 787: ,x_standard_operation_id =>new_std_op_id

783:
784: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id) LOOP
785: new_row_id := null;
786: b_std_op_res_pkg.Insert_Row( x_rowid =>new_row_id
787: ,x_standard_operation_id =>new_std_op_id
788: ,x_resource_id =>std_op_res_rec.resource_id
789: ,x_activity_id =>std_op_res_rec.activity_id
790: ,x_last_update_date =>sysdate
791: ,x_last_updated_by =>fnd_global.user_id

Line 800: ,x_standard_rate_flag =>std_op_res_rec.standard_rate_flag

796: ,x_usage_rate_or_amount =>std_op_res_rec.usage_rate_or_amount
797: ,x_usage_rate_or_amount_inverse =>std_op_res_rec.usage_rate_or_amount_inverse
798: ,x_basis_type =>std_op_res_rec.basis_type
799: ,x_autocharge_type =>std_op_res_rec.autocharge_type
800: ,x_standard_rate_flag =>std_op_res_rec.standard_rate_flag
801: ,x_assigned_units =>std_op_res_rec.assigned_units
802: ,x_schedule_flag =>std_op_res_rec.schedule_flag
803: ,x_attribute_category =>std_op_res_rec.attribute_category
804: ,x_attribute1 =>std_op_res_rec.attribute1

Line 844: l_operation_tbl(j).Standard_Operation_Code := null;

840: l_operation_tbl(j).Operation_Type := null;
841: l_operation_tbl(j).Start_Effective_Date := null;
842: l_operation_tbl(j).New_Operation_Sequence_Number := null;
843: l_operation_tbl(j).New_Start_Effective_Date := null;
844: l_operation_tbl(j).Standard_Operation_Code := null;
845: l_operation_tbl(j).Department_Code := null;
846: l_operation_tbl(j).Op_Lead_Time_Percent := null;
847: l_operation_tbl(j).Minimum_Transfer_Quantity := null;
848: l_operation_tbl(j).Count_Point_Type := null;

Line 898: l_operation_tbl(j).Standard_Operation_Code := l_operations_rec.Standard_Operation_Code;

894: l_operation_tbl(j).Operation_Type := l_operations_rec.Operation_Type;
895: l_operation_tbl(j).Start_Effective_Date := l_operations_rec.Start_Effective_Date;
896: l_operation_tbl(j).New_Operation_Sequence_Number := l_operations_rec.New_Operation_Sequence_Number;
897: l_operation_tbl(j).New_Start_Effective_Date := l_operations_rec.New_Start_Effective_Date;
898: l_operation_tbl(j).Standard_Operation_Code := l_operations_rec.Standard_Operation_Code;
899: l_operation_tbl(j).Department_Code := l_operations_rec.Department_Code;
900: l_operation_tbl(j).Op_Lead_Time_Percent := l_operations_rec.Op_Lead_Time_Percent;
901: l_operation_tbl(j).Minimum_Transfer_Quantity := l_operations_rec.Minimum_Transfer_Quantity;
902: l_operation_tbl(j).Count_Point_Type := l_operations_rec.Count_Point_Type;

Line 956: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).process_code then

952: jj := l_operation_tbl.LAST;
953: LOOP
954: if l_operation_tbl(ii).operation_type = 2 and
955: l_operation_tbl(ii).operation_sequence_number = l_operation_tbl(j).process_seq_number and
956: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).process_code then
957: process_in_list := true;
958: end if;
959:
960: if l_operation_tbl(ii).operation_type = 3 and

Line 962: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).line_op_code then

958: end if;
959:
960: if l_operation_tbl(ii).operation_type = 3 and
961: l_operation_tbl(ii).operation_sequence_number = l_operation_tbl(j).line_op_seq_number and
962: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).line_op_code then
963: lineop_in_list := true;
964: end if;
965:
966: exit when ii = jj;

Line 1215: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);

1211:
1212: -- both RTG and/or BOM copied, then copy attachments
1213: if (o_return_status = 'S') then
1214: if l_2_ids.COUNT > 0 then
1215: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);
1216: end if;
1217: if a_operation_tbl.COUNT > 0 then
1218:
1219: l_new_rtg_seq_id := null;