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 445: BOM_OP_SEQUENCES_INTERFACE

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

Line 476: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 498: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 520: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 542: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 561: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 584: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 598: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 615: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 637: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 659: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 680: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 703: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 773: FROM BOM_OP_SEQUENCES_INTERFACE

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

Line 836: FROM BOM_OP_SEQUENCES_INTERFACE

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

Line 899: FROM BOM_OP_SEQUENCES_INTERFACE

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

Line 952: 'BOM_OP_SEQUENCES_INTERFACE',

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

Line 964: from BOM_OP_SEQUENCES_INTERFACE BOSI

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

Line 975: Update BOM_OP_SEQUENCES_INTERFACE

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