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 87: bom_operation_sequences bos

83: select bor.organization_id,
84: bor.line_id,
85: bos.standard_operation_id
86: from bom_operational_routings bor,
87: bom_operation_sequences bos
88: where bos.routing_sequence_id = bor.routing_sequence_id
89: and bos.operation_sequence_id = i_op_seq_id;
90:
91: BEGIN

Line 224: bom_operation_sequences bos

220: -- get parameter
221: select bor.organization_id, bor.line_id, bos.standard_operation_id
222: into l_org_id, l_line_id, l_std_op_id
223: from bom_operational_routings bor,
224: bom_operation_sequences bos
225: where bos.routing_sequence_id = bor.routing_sequence_id
226: and bos.operation_sequence_id = i_op_seq_id;
227: -- get enabled
228: get_workstation_enabled(

Line 256: from bom_operation_sequences bos,

252: -- corresponding to the schedule that references the specified
253: -- standard operation.
254: CURSOR op_seq_csr IS
255: select bos.operation_sequence_id
256: from bom_operation_sequences bos,
257: wip_flow_schedules wfs,
258: bom_operational_routings bor
259: where wfs.wip_entity_id = i_wip_entity_id
260: and bor.organization_id = i_org_id

Line 270: from bom_operation_sequences bos,

266: -- Cursor to find out starting operations of this routing
267: CURSOR start_op_csr IS
268: select bos.operation_sequence_id seq_id,
269: bos.operation_seq_num seq_num
270: from bom_operation_sequences bos,
271: wip_flow_schedules wfs,
272: bom_operational_routings bor
273: where wfs.wip_entity_id = i_wip_entity_id
274: and bor.organization_id = i_org_id

Line 738: from bom_operation_networks, bom_operation_sequences

734: (
735: select myFrom, operation_seq_num from
736: (
737: select from_op_seq_id myFrom, to_op_seq_id, transition_type, operation_seq_num
738: from bom_operation_networks, bom_operation_sequences
739: where from_op_seq_id = operation_sequence_id
740: start with to_op_seq_id = l_op_seq_id and transition_type in (1,2)
741: connect by PRIOR from_op_seq_id = to_op_seq_id
742: and transition_type in (1,2)

Line 761: from bom_operation_sequences

757: and from_op_seq_id not in (l_from_op_seq_id);
758:
759: cursor op_seq_num_csr IS
760: select operation_seq_num
761: from bom_operation_sequences
762: where operation_sequence_id = l_op_seq_id;
763:
764: cursor incoming_op_count_csr IS
765: select count(from_op_seq_id) op_count

Line 915: from bom_operation_sequences

911: p_wip_entity_id IN NUMBER,
912: x_lop_tbl OUT NOCOPY operation_seq_tbl_type) IS
913: CURSOR all_ops(p_rtg_seq_id NUMBER) IS
914: select operation_sequence_id
915: from bom_operation_sequences
916: where routing_sequence_id = p_rtg_seq_id
917: and operation_type = 3;
918:
919: CURSOR lowest_op(p_rtg_seq_id NUMBER) IS

Line 921: from bom_operation_sequences

917: and operation_type = 3;
918:
919: CURSOR lowest_op(p_rtg_seq_id NUMBER) IS
920: select operation_sequence_id
921: from bom_operation_sequences
922: where routing_sequence_id = p_rtg_seq_id
923: and operation_type = 3
924: and operation_seq_num = (
925: select min(operation_seq_num)

Line 926: from bom_operation_sequences

922: where routing_sequence_id = p_rtg_seq_id
923: and operation_type = 3
924: and operation_seq_num = (
925: select min(operation_seq_num)
926: from bom_operation_sequences
927: where routing_sequence_id = p_rtg_seq_id
928: and operation_type = 3);
929:
930:

Line 949: from bom_operation_networks, bom_operation_sequences

945: order by operation_sequence_id;
946:
947: CURSOR primary_ops(p_op_seq_id NUMBER) IS
948: select from_op_seq_id, to_op_seq_id, transition_type, operation_seq_num
949: from bom_operation_networks, bom_operation_sequences
950: where from_op_seq_id = operation_sequence_id and transition_type=1
951: start with from_op_seq_id = p_op_seq_id
952: connect by PRIOR to_op_seq_id = from_op_seq_id
953: and prior transition_type =1;

Line 957: from bom_operation_sequences

953: and prior transition_type =1;
954:
955: CURSOR event_seq_num (p_rtg_seq_id NUMBER, p_lop_seq_id NUMBER) IS
956: select operation_seq_num
957: from bom_operation_sequences
958: where routing_sequence_id = p_rtg_seq_id
959: and line_op_seq_id = p_lop_seq_id
960: and operation_type = 1;
961:

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

970: l_all_op_seq_tbl operation_seq_tbl_type;
971: v_idx NUMBER;
972: l_bf_option NUMBER;
973: l_event_seq_num_tbl operation_seq_tbl_type;
974: TYPE event_seq_num_tbl_type IS TABLE OF APPS.BOM_OPERATION_SEQUENCES.OPERATION_SEQ_NUM%TYPE;
975: l_event_seq_num_tbl1 event_seq_num_tbl_type;
976: l_completed_op_exist boolean := false;
977: l_op_count NUMBER;
978:

Line 1239: from bom_operation_sequences

1235:
1236:
1237: CURSOR op_events (p_rtg_seq_id NUMBER, p_lop_seq_id NUMBER) IS
1238: select operation_sequence_id, operation_seq_num
1239: from bom_operation_sequences
1240: where routing_sequence_id = p_rtg_seq_id
1241: and line_op_seq_id = p_lop_seq_id
1242: and operation_type = 1;
1243: