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.BOMPPRCB dependencies on BOM_OPERATION_SEQUENCES

Line 599: table_name := 'BOM_OPERATION_SEQUENCES';

595: /*
596: ** Process operation sequences interface table
597: */
598: stmt_num := 80;
599: table_name := 'BOM_OPERATION_SEQUENCES';
600: insert into BOM_OPERATION_SEQUENCES
601: (
602: OPERATION_SEQUENCE_ID,
603: ROUTING_SEQUENCE_ID,

Line 600: insert into BOM_OPERATION_SEQUENCES

596: ** Process operation sequences interface table
597: */
598: stmt_num := 80;
599: table_name := 'BOM_OPERATION_SEQUENCES';
600: insert into BOM_OPERATION_SEQUENCES
601: (
602: OPERATION_SEQUENCE_ID,
603: ROUTING_SEQUENCE_ID,
604: OPERATION_SEQ_NUM,

Line 867: bom_operation_sequences bos1, /* 'from' Ops of model */

863: bon.ATTRIBUTE13,
864: bon.ATTRIBUTE14,
865: bon.ATTRIBUTE15
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif

Line 868: bom_operation_sequences bos2, /* 'to' Ops of model */

864: bon.ATTRIBUTE14,
865: bon.ATTRIBUTE15
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 869: bom_operation_sequences bos3, /* 'from' Ops of config */

865: bon.ATTRIBUTE15
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
873: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 870: bom_operation_sequences bos4, /* 'to' Ops of config */

866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
873: AND bon.to_op_seq_id = bos2.operation_sequence_id
874: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 915: X_from_entity_name =>'BOM_OPERATION_SEQUENCES',

911:
912: for nextop in allops loop
913:
914: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
915: X_from_entity_name =>'BOM_OPERATION_SEQUENCES',
916: X_from_pk1_value =>nextop.model_op_seq_id,
917: X_from_pk2_value =>'',
918: X_from_pk3_value =>'',
919: X_from_pk4_value =>'',

Line 921: X_to_entity_name =>'BOM_OPERATION_SEQUENCES',

917: X_from_pk2_value =>'',
918: X_from_pk3_value =>'',
919: X_from_pk4_value =>'',
920: X_from_pk5_value =>'',
921: X_to_entity_name =>'BOM_OPERATION_SEQUENCES',
922: X_to_pk1_value =>nextop.operation_sequence_id,
923: X_to_pk2_value =>'',
924: X_to_pk3_value =>'',
925: X_to_pk4_value =>'',

Line 2082: table_name := 'BOM_OPERATION_SEQUENCES';

2078: ** Process operation sequences interface tables
2079: */
2080:
2081: stmt_num := 20;
2082: table_name := 'BOM_OPERATION_SEQUENCES';
2083: loop
2084: insert into BOM_OPERATION_SEQUENCES
2085: (
2086: OPERATION_SEQUENCE_ID,

Line 2084: insert into BOM_OPERATION_SEQUENCES

2080:
2081: stmt_num := 20;
2082: table_name := 'BOM_OPERATION_SEQUENCES';
2083: loop
2084: insert into BOM_OPERATION_SEQUENCES
2085: (
2086: OPERATION_SEQUENCE_ID,
2087: ROUTING_SEQUENCE_ID,
2088: OPERATION_SEQ_NUM,

Line 2175: and exists (select NULL from bom_operation_sequences bos

2171:
2172: update bom_op_sequences_interface bsi
2173: set process_flag = 7
2174: where process_flag = 4
2175: and exists (select NULL from bom_operation_sequences bos
2176: where bos.operation_sequence_id =
2177: bsi.operation_sequence_id);
2178: commit;
2179: end loop;