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.BOM_RTG_OI_UTIL dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 29: G_OprDelEntity constant varchar2(30) := 'BOM_OP_SEQUENCES_INTERFACE';

25: G_Create constant varchar2(10) := 'CREATE'; -- transaction type
26: G_Update constant varchar2(10) := 'UPDATE'; -- transaction type
27: G_Delete constant varchar2(10) := 'DELETE'; -- transaction type
28: G_RtgDelEntity constant varchar2(30) := 'BOM_OP_ROUTINGS_INTERFACE';
29: G_OprDelEntity constant varchar2(30) := 'BOM_OP_SEQUENCES_INTERFACE';
30:
31: /*--------------------------Process_Header_Info------------------------------
32:
33: NAME

Line 443: BOM_OP_SEQUENCES_INTERFACE

439: Populate the user-friendly columns to operation records in the interface table
440: REQUIRES
441:
442: MODIFIES
443: BOM_OP_SEQUENCES_INTERFACE
444: MTL_INTERFACE_ERRORS
445: RETURNS
446: 0 if successful
447: SQLCODE if unsuccessful

Line 474: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

470: BEGIN
471: stmt_num := 1;
472: /* Resolve the routing_sequence_ids for updates and deletes */
473:
474: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
475: SET(routing_sequence_id, effectivity_date,
476: operation_seq_num, operation_type)
477: = (SELECT routing_sequence_id, effectivity_date, operation_seq_num, operation_type
478: FROM BOM_OPERATION_SEQUENCES BOS1

Line 496: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

492:
493: stmt_num := 2;
494: /* Resolve the assembly item ids */
495:
496: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
497: SET(assembly_item_id, organization_id, alternate_routing_designator)
498: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
499: FROM BOM_OPERATIONAL_ROUTINGS BOR1
500: WHERE BOR1.routing_sequence_id = BOSI.routing_sequence_id)

Line 518: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

514: stmt_num := 3;
515: /* Update Organization Code using Organization_id
516: this also needed if Organization_id is given and code is not given*/
517:
518: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
519: SET organization_code = (SELECT organization_code
520: FROM MTL_PARAMETERS mp1
521: WHERE mp1.organization_id = BOSI.organization_id)
522: WHERE process_flag = 1

Line 540: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

536: stmt_num := 4;
537: /* Update Organization_ids if organization_code is given org id is null.
538: Orgnaization_id information is needed in the next steps */
539:
540: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
541: SET organization_id = (SELECT organization_id
542: FROM MTL_PARAMETERS mp1
543: WHERE mp1.organization_code = BOSI.organization_code)
544: WHERE process_flag = 1

Line 559: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

555:
556: stmt_num := 5;
557: /* Update Assembly Item name */
558:
559: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
560: SET assembly_item_number = (SELECT concatenated_segments
561: FROM MTL_SYSTEM_ITEMS_KFV mvl1
562: WHERE mvl1.inventory_item_id = BOSI.assembly_item_id
563: and mvl1.organization_id = BOSI.organization_id)

Line 582: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

578:
579: stmt_num := 6;
580: /* Assign transaction ids */
581:
582: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
583: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
584: WHERE transaction_id is null
585: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
586: AND process_flag = 1

Line 596: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

592: AND (all_org = 1
593: OR
594: (all_org = 2 AND organization_id = org_id));
595:
596: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
597: SET transaction_type = upper(transaction_type)
598: WHERE upper(transaction_type) in (G_Create, G_Update, G_Delete)
599: AND process_flag = 1
600: AND

Line 613: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

609:
610: stmt_num := 7;
611: /* Update the operation code from the standard operation id */
612:
613: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
614: SET operation_code = (SELECT operation_code
615: FROM BOM_STANDARD_OPERATIONS bso
616: WHERE bso.standard_operation_id = BOSI.standard_operation_id
617: and bso.organization_id = BOSI.organization_id)

Line 635: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

631:
632: stmt_num := 8;
633: /* Update the department code from the department id */
634:
635: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
636: SET department_code = (SELECT department_code
637: FROM BOM_DEPARTMENTS bd
638: WHERE bd.department_id = BOSI.department_id
639: and bd.organization_id = BOSI.organization_id)

Line 657: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

653:
654: stmt_num := 9;
655: /* Resolve the line_op_seq_ids and process_op_seq_ids */
656:
657: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
658: SET(line_op_seq_number, line_op_code)
659: = (SELECT bos1.operation_seq_num, bso1.operation_code
660: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1
661: WHERE BOS1.operation_sequence_id = BOSI.line_op_seq_id

Line 678: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

674: WHERE BOS1.operation_sequence_id = BOSI.line_op_seq_id
675: AND BSO1.organization_id = BOSI.organization_id
676: AND BOS1.standard_operation_id = BSO1.standard_operation_id);
677:
678: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
679: SET(process_seq_number, process_code)
680: = (SELECT bos1.operation_seq_num, bso1.operation_code
681: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1
682: WHERE BOS1.operation_sequence_id = BOSI.process_op_seq_id

Line 701: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

697: AND BOS1.standard_operation_id = BSO1.standard_operation_id);
698:
699: stmt_num := 10;
700: /* Update the delete_group_name from bom_interface_delete_groups */
701: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
702: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
703: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
704: FROM bom_interface_delete_groups
705: Where upper(entity_name) = G_OprDelEntity

Line 771: FROM BOM_OP_SEQUENCES_INTERFACE

767: 10,
768: 1,
769: G_Create,
770: BATCH_ID
771: FROM BOM_OP_SEQUENCES_INTERFACE
772: WHERE process_flag = 1
773: AND transaction_type = G_Create
774: AND
775: (

Line 834: FROM BOM_OP_SEQUENCES_INTERFACE

830: 20,
831: 1,
832: G_Create,
833: BATCH_ID
834: FROM BOM_OP_SEQUENCES_INTERFACE
835: WHERE process_flag = 1
836: AND transaction_type = G_Create
837: AND
838: (

Line 897: FROM BOM_OP_SEQUENCES_INTERFACE

893: 30,
894: 1,
895: G_Create,
896: BATCH_ID
897: FROM BOM_OP_SEQUENCES_INTERFACE
898: WHERE process_flag = 1
899: AND transaction_type = G_Create
900: AND
901: (

Line 950: 'BOM_OP_SEQUENCES_INTERFACE',

946: BOSI.transaction_id,
947: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
948: Null,
949: null,
950: 'BOM_OP_SEQUENCES_INTERFACE',
951: decode ( BOSI.Organization_code, null, msg_name1,msg_name2),
952: decode ( BOSI.Organization_code, null, msg_text1,msg_text2),
953: NVL(LAST_UPDATE_DATE, SYSDATE),
954: NVL(LAST_UPDATED_BY, user_id),

Line 962: from BOM_OP_SEQUENCES_INTERFACE BOSI

958: NVL(REQUEST_ID, req_id),
959: NVL(PROGRAM_APPLICATION_ID, prog_appid),
960: NVL(PROGRAM_ID, prog_id),
961: NVL(PROGRAM_UPDATE_DATE, sysdate)
962: from BOM_OP_SEQUENCES_INTERFACE BOSI
963: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
964: and transaction_id is not null
965: and process_flag = 1
966: and

Line 973: Update BOM_OP_SEQUENCES_INTERFACE

969: OR ( p_batch_id = batch_id )
970: )
971: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id)) ;
972:
973: Update BOM_OP_SEQUENCES_INTERFACE
974: set process_flag = 3
975: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
976: and transaction_id is not null
977: and process_flag = 1