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_EXECUTION_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 161: bom_operation_sequences bos

157: select bor.organization_id,
158: bor.line_id,
159: bos.standard_operation_id
160: from bom_operational_routings bor,
161: bom_operation_sequences bos
162: where bos.routing_sequence_id = bor.routing_sequence_id
163: and bos.operation_sequence_id = i_op_seq_id;
164:
165: BEGIN

Line 306: bom_operation_sequences bos

302: -- get parameter
303: select bor.organization_id, bor.line_id, bos.standard_operation_id
304: into l_org_id, l_line_id, l_std_op_id
305: from bom_operational_routings bor,
306: bom_operation_sequences bos
307: where bos.routing_sequence_id = bor.routing_sequence_id
308: and bos.operation_sequence_id = i_op_seq_id;
309: -- get enabled
310: IF(G_WORKSTATION_ENABLED = 'U') THEN

Line 341: from bom_operation_sequences bos,

337: l_op_seq_id NUMBER := 0;
338:
339: BEGIN
340: select bos.operation_sequence_id into l_op_seq_id
341: from bom_operation_sequences bos,
342: wip_flow_schedules wfs,
343: bom_operational_routings bor
344: where wfs.wip_entity_id = i_wip_entity_id
345: and bor.organization_id = i_org_id

Line 440: from bom_operation_sequences bos,

436: -- corresponding to the schedule that references the specified
437: -- standard operation.
438: CURSOR op_seq_csr IS
439: select bos.operation_sequence_id
440: from bom_operation_sequences bos,
441: wip_flow_schedules wfs,
442: bom_operational_routings bor
443: where wfs.wip_entity_id = i_wip_entity_id
444: and bor.organization_id = i_org_id

Line 454: from bom_operation_sequences bos,

450: -- Cursor to find out starting operations of this routing
451: CURSOR start_op_csr IS
452: select bos.operation_sequence_id seq_id,
453: bos.operation_seq_num seq_num
454: from bom_operation_sequences bos,
455: wip_flow_schedules wfs,
456: bom_operational_routings bor
457: where wfs.wip_entity_id = i_wip_entity_id
458: and bor.organization_id = i_org_id

Line 955: from bom_operation_networks, bom_operation_sequences

951: (
952: select myFrom, operation_seq_num from
953: (
954: select from_op_seq_id myFrom, to_op_seq_id, transition_type, operation_seq_num
955: from bom_operation_networks, bom_operation_sequences
956: where from_op_seq_id = operation_sequence_id
957: start with to_op_seq_id = l_op_seq_id and transition_type in (1,2)
958: connect by PRIOR from_op_seq_id = to_op_seq_id
959: and transition_type in (1,2)

Line 978: from bom_operation_sequences

974: and from_op_seq_id not in (l_from_op_seq_id);
975:
976: cursor op_seq_num_csr IS
977: select operation_seq_num
978: from bom_operation_sequences
979: where operation_sequence_id = l_op_seq_id;
980:
981: cursor incoming_op_count_csr IS
982: select count(from_op_seq_id) op_count

Line 1132: from bom_operation_sequences

1128: p_wip_entity_id IN NUMBER,
1129: x_lop_tbl OUT NOCOPY operation_seq_tbl_type) IS
1130: CURSOR all_ops(p_rtg_seq_id NUMBER) IS
1131: select operation_sequence_id
1132: from bom_operation_sequences
1133: where routing_sequence_id = p_rtg_seq_id
1134: and operation_type = 3;
1135:
1136: CURSOR lowest_op(p_rtg_seq_id NUMBER) IS

Line 1138: from bom_operation_sequences

1134: and operation_type = 3;
1135:
1136: CURSOR lowest_op(p_rtg_seq_id NUMBER) IS
1137: select operation_sequence_id
1138: from bom_operation_sequences
1139: where routing_sequence_id = p_rtg_seq_id
1140: and operation_type = 3
1141: and operation_seq_num = (
1142: select min(operation_seq_num)

Line 1143: from bom_operation_sequences

1139: where routing_sequence_id = p_rtg_seq_id
1140: and operation_type = 3
1141: and operation_seq_num = (
1142: select min(operation_seq_num)
1143: from bom_operation_sequences
1144: where routing_sequence_id = p_rtg_seq_id
1145: and operation_type = 3);
1146:
1147:

Line 1166: from bom_operation_networks, bom_operation_sequences

1162: order by operation_sequence_id;
1163:
1164: CURSOR primary_ops(p_op_seq_id NUMBER) IS
1165: select from_op_seq_id, to_op_seq_id, transition_type, operation_seq_num
1166: from bom_operation_networks, bom_operation_sequences
1167: where from_op_seq_id = operation_sequence_id and transition_type=1
1168: start with from_op_seq_id = p_op_seq_id
1169: connect by PRIOR to_op_seq_id = from_op_seq_id
1170: and prior transition_type =1;

Line 1174: from bom_operation_sequences

1170: and prior transition_type =1;
1171:
1172: CURSOR event_seq_num (p_rtg_seq_id NUMBER, p_lop_seq_id NUMBER) IS
1173: select operation_seq_num
1174: from bom_operation_sequences
1175: where routing_sequence_id = p_rtg_seq_id
1176: and line_op_seq_id = p_lop_seq_id
1177: and operation_type = 1;
1178:

Line 1191: TYPE event_seq_num_tbl_type IS TABLE OF APPS.BOM_OPERATION_SEQUENCES.OPERATION_SEQ_NUM%TYPE;

1187: l_all_op_seq_tbl operation_seq_tbl_type;
1188: v_idx NUMBER;
1189: l_bf_option NUMBER;
1190: l_event_seq_num_tbl operation_seq_tbl_type;
1191: TYPE event_seq_num_tbl_type IS TABLE OF APPS.BOM_OPERATION_SEQUENCES.OPERATION_SEQ_NUM%TYPE;
1192: l_event_seq_num_tbl1 event_seq_num_tbl_type;
1193: l_completed_op_exist boolean := false;
1194: l_op_count NUMBER;
1195:

Line 1459: from bom_operation_sequences

1455:
1456:
1457: CURSOR op_events (p_rtg_seq_id NUMBER, p_lop_seq_id NUMBER) IS
1458: select operation_sequence_id, operation_seq_num
1459: from bom_operation_sequences
1460: where routing_sequence_id = p_rtg_seq_id
1461: and line_op_seq_id = p_lop_seq_id
1462: and operation_type = 1;
1463:

Line 2229: from bom_operation_sequences bos,

2225: CURSOR op_seq_csr IS
2226: select bos.operation_sequence_id, bor.common_routing_sequence_id,
2227: nvl(wfs.routing_revision_date, wfs.scheduled_completion_date)
2228: as routing_revision_date
2229: from bom_operation_sequences bos,
2230: wip_flow_schedules wfs,
2231: bom_operational_routings bor
2232: where wfs.wip_entity_id = p_wip_entity_id
2233: and wfs.organization_id = p_org_id

Line 2248: from bom_operation_sequences bos

2244: select 'Y' as event_exist
2245: from dual
2246: where exists (
2247: select bos.operation_sequence_id
2248: from bom_operation_sequences bos
2249: where bos.routing_sequence_id = l_common_routing_seq_id
2250: and bos.line_op_seq_id = l_operation_seq_id
2251: and bos.operation_type = 1
2252: and bos.effectivity_date <= l_rtg_rev_date