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

Line 206: from BOM_OP_SEQUENCES_INTERFACE b1,

202: b1.operation_seq_num,
203: b1.operation_type,
204: b1.routing_sequence_id,
205: b1.last_update_login
206: from BOM_OP_SEQUENCES_INTERFACE b1,
207: BOM_OP_SEQUENCES_INTERFACE b2,
208: BOM_OP_ROUTINGS_INTERFACE r2
209: where r2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
210: and b2.routing_sequence_id = r2.routing_sequence_id

Line 207: BOM_OP_SEQUENCES_INTERFACE b2,

203: b1.operation_type,
204: b1.routing_sequence_id,
205: b1.last_update_login
206: from BOM_OP_SEQUENCES_INTERFACE b1,
207: BOM_OP_SEQUENCES_INTERFACE b2,
208: BOM_OP_ROUTINGS_INTERFACE r2
209: where r2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
210: and b2.routing_sequence_id = r2.routing_sequence_id
211: and b1.routing_sequence_id = b2.routing_sequence_id

Line 1261: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE

1257: /*
1258: ** Zero:
1259: ** ALL Processes and Line operations ,
1260: ** associated with the model/option classes will
1261: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE
1262: */
1263: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1264: stmt_num := 130;
1265: insert into BOM_OP_SEQUENCES_INTERFACE

Line 1263: table_name := 'BOM_OP_SEQUENCES_INTERFACE';

1259: ** ALL Processes and Line operations ,
1260: ** associated with the model/option classes will
1261: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE
1262: */
1263: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1264: stmt_num := 130;
1265: insert into BOM_OP_SEQUENCES_INTERFACE
1266: (
1267: OPERATION_SEQUENCE_ID,

Line 1265: insert into BOM_OP_SEQUENCES_INTERFACE

1261: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE
1262: */
1263: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1264: stmt_num := 130;
1265: insert into BOM_OP_SEQUENCES_INTERFACE
1266: (
1267: OPERATION_SEQUENCE_ID,
1268: ROUTING_SEQUENCE_ID,
1269: OPERATION_SEQ_NUM,

Line 1416: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE

1412: /*
1413: ** First:
1414: ** All operations/events with NO in option_dependent_flag,
1415: ** associated with the model/option classes will
1416: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE
1417: */
1418: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1419: stmt_num := 130;
1420: insert into BOM_OP_SEQUENCES_INTERFACE

Line 1418: table_name := 'BOM_OP_SEQUENCES_INTERFACE';

1414: ** All operations/events with NO in option_dependent_flag,
1415: ** associated with the model/option classes will
1416: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE
1417: */
1418: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1419: stmt_num := 130;
1420: insert into BOM_OP_SEQUENCES_INTERFACE
1421: (
1422: OPERATION_SEQUENCE_ID,

Line 1420: insert into BOM_OP_SEQUENCES_INTERFACE

1416: ** be inserted into the BOM_OP_SEQUENCES_INTERFACE
1417: */
1418: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1419: stmt_num := 130;
1420: insert into BOM_OP_SEQUENCES_INTERFACE
1421: (
1422: OPERATION_SEQUENCE_ID,
1423: ROUTING_SEQUENCE_ID,
1424: OPERATION_SEQ_NUM,

Line 1573: ** will be inserted into BOM_OP_SEQUENCES_INTERFACE.

1569: /*
1570: ** Second:
1571: ** All operations/events with YES in option_dependent_flag,
1572: ** associated with the chosen option items/option classes
1573: ** will be inserted into BOM_OP_SEQUENCES_INTERFACE.
1574: */
1575: stmt_num := 140;
1576: insert into BOM_OP_SEQUENCES_INTERFACE
1577: (

Line 1576: insert into BOM_OP_SEQUENCES_INTERFACE

1572: ** associated with the chosen option items/option classes
1573: ** will be inserted into BOM_OP_SEQUENCES_INTERFACE.
1574: */
1575: stmt_num := 140;
1576: insert into BOM_OP_SEQUENCES_INTERFACE
1577: (
1578: OPERATION_SEQUENCE_ID,
1579: ROUTING_SEQUENCE_ID,
1580: OPERATION_SEQ_NUM,

Line 1755: insert into BOM_OP_SEQUENCES_INTERFACE

1751: are option dependent and have a standard mandatory
1752: component at that operation
1753: */
1754: stmt_num := 150;
1755: insert into BOM_OP_SEQUENCES_INTERFACE
1756: (
1757: OPERATION_SEQUENCE_ID,
1758: ROUTING_SEQUENCE_ID,
1759: OPERATION_SEQ_NUM,

Line 1949: delete from BOM_OP_SEQUENCES_INTERFACE

1945:
1946: if save_routing_id = routing_id and
1947: save_op_seq_num = op_seq_num and
1948: save_op_type = op_type then
1949: delete from BOM_OP_SEQUENCES_INTERFACE
1950: where operation_sequence_id = op_seq_id;
1951: else
1952: save_routing_id := routing_id;
1953: save_op_seq_num := op_seq_num;

Line 1966: update bom_op_sequences_interface bos1

1962: ** Old operation_sequence_ids are available in model_op_seq_id
1963: */
1964:
1965: stmt_num := 160;
1966: update bom_op_sequences_interface bos1
1967: set process_op_seq_id = (
1968: select operation_sequence_id
1969: from bom_op_sequences_interface bos2,
1970: bom_op_routings_interface b

Line 1969: from bom_op_sequences_interface bos2,

1965: stmt_num := 160;
1966: update bom_op_sequences_interface bos1
1967: set process_op_seq_id = (
1968: select operation_sequence_id
1969: from bom_op_sequences_interface bos2,
1970: bom_op_routings_interface b
1971: where bos1.process_op_seq_id = bos2.model_op_seq_id
1972: and bos1.routing_sequence_id = b.routing_sequence_id
1973: and bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1977: update bom_op_sequences_interface bos1

1973: and bos1.routing_sequence_id = bos2.routing_sequence_id
1974: and b.set_id = to_char(to_number(USERENV('SESSIONID'))))
1975: where bos1.operation_type = 1;
1976:
1977: update bom_op_sequences_interface bos1
1978: set line_op_seq_id = (
1979: select operation_sequence_id
1980: from bom_op_sequences_interface bos2,
1981: bom_op_routings_interface b

Line 1980: from bom_op_sequences_interface bos2,

1976:
1977: update bom_op_sequences_interface bos1
1978: set line_op_seq_id = (
1979: select operation_sequence_id
1980: from bom_op_sequences_interface bos2,
1981: bom_op_routings_interface b
1982: where bos1.line_op_seq_id = bos2.model_op_seq_id
1983: and bos1.routing_sequence_id = b.routing_sequence_id
1984: and bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1999: from BOM_OP_SEQUENCES_INTERFACE b2

1995:
1996: delete from BOM_OP_ROUTINGS_INTERFACE b1
1997: where b1.routing_sequence_id not in
1998: (select b2.routing_sequence_id
1999: from BOM_OP_SEQUENCES_INTERFACE b2
2000: where b2.routing_sequence_id = b1.routing_sequence_id)
2001: and b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
2002:
2003: /*

Line 2008: delete BOM_OP_SEQUENCES_INTERFACE si

2004: ** Handle the selected operations that do not belong
2005: ** to the routing of the model/option class.
2006: man: This delete is not required.
2007:
2008: delete BOM_OP_SEQUENCES_INTERFACE si
2009: where operation_seq_num not in
2010: (select /o+ ORDERED o/
2011: s.operation_seq_num
2012: from

Line 2048: BOM_OP_SEQUENCES_INTERFACE oi,

2044: set ci.operation_seq_num = 1
2045: where not exists
2046: (select 'op seq exists in config routing'
2047: from
2048: BOM_OP_SEQUENCES_INTERFACE oi,
2049: BOM_OP_ROUTINGS_INTERFACE ri,
2050: BOM_BILL_OF_MTLS_INTERFACE bi
2051: where ci.bill_sequence_id = bi.bill_sequence_id
2052: and oi.operation_seq_num = ci.operation_seq_num

Line 2236: bom_op_sequences_interface osi,

2232: NULL, /* program_application_id */
2233: NULL, /* program_id */
2234: NULL /* program_update_date */
2235: from
2236: bom_op_sequences_interface osi,
2237: bom_operation_resources bor,
2238: bom_op_routings_interface b
2239: where
2240: osi.routing_sequence_id = b.routing_sequence_id