APPS.FLM_EXECUTION_UTIL dependencies on STANDARD

Line 23: AND STANDARD_OPERATION_ID = l_operation_id;

19: SELECT VIEW_ALL_SCHEDULES
20: FROM FLM_EXE_PREFERENCES
21: WHERE ORGANIZATION_ID = l_org_id
22: AND LINE_ID = l_line_id
23: AND STANDARD_OPERATION_ID = l_operation_id;
24:
25: CURSOR c_view_all_line IS
26: SELECT VIEW_ALL_SCHEDULES
27: FROM FLM_EXE_PREFERENCES

Line 30: AND STANDARD_OPERATION_ID IS NULL;

26: SELECT VIEW_ALL_SCHEDULES
27: FROM FLM_EXE_PREFERENCES
28: WHERE ORGANIZATION_ID = l_org_id
29: AND LINE_ID = l_line_id
30: AND STANDARD_OPERATION_ID IS NULL;
31:
32: CURSOR c_view_all_org IS
33: SELECT VIEW_ALL_SCHEDULES
34: FROM FLM_EXE_PREFERENCES

Line 37: AND STANDARD_OPERATION_ID IS NULL;

33: SELECT VIEW_ALL_SCHEDULES
34: FROM FLM_EXE_PREFERENCES
35: WHERE ORGANIZATION_ID = l_org_id
36: AND LINE_ID IS NULL
37: AND STANDARD_OPERATION_ID IS NULL;
38:
39: BEGIN
40: l_org_id := p_organization_id;
41: l_line_id := p_line_id;

Line 85: bos.standard_operation_id

81:
82: CURSOR c_rtg IS
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;

Line 96: l_std_op_id := c_rtg_rec.standard_operation_id;

92:
93: FOR c_rtg_rec in c_rtg LOOP
94: l_org_id := c_rtg_rec.organization_id;
95: l_line_id := c_rtg_rec.line_id;
96: l_std_op_id := c_rtg_rec.standard_operation_id;
97: END LOOP;
98: l_view_all_sch := get_view_all_schedules(l_org_id, l_line_id, l_std_op_id);
99:
100: return (l_view_all_sch);

Line 144: NVL(STANDARD_OPERATION_ID,-1) = nvl(l_operation_id,-1);

140: FLM_EXE_PREFERENCES
141: WHERE
142: NVL(ORGANIZATION_ID,-1) = NVL(l_org_id,-1) AND
143: NVL(LINE_ID,-1) = NVL(l_line_id,-1) AND
144: NVL(STANDARD_OPERATION_ID,-1) = nvl(l_operation_id,-1);
145:
146: BEGIN
147:
148: --SAVEPOINT get_workstation_enabled;

Line 221: select bor.organization_id, bor.line_id, bos.standard_operation_id

217: l_msg_cnt NUMBER;
218: l_msg VARCHAR2(2000);
219: BEGIN
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

Line 253: -- standard operation.

249: l_op_seq_id NUMBER := 0;
250:
251: -- Cursor to find the sequence id of the operation in the routing
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,

Line 265: and bos.standard_operation_id = i_std_op_id;

261: and bor.assembly_item_id = wfs.primary_item_id
262: and nvl(bor.alternate_routing_designator, '########') = nvl(wfs.alternate_routing_designator, '########')
263: and bor.common_routing_sequence_id = bos.routing_sequence_id
264: and bos.operation_type = 3 -- line operation
265: and bos.standard_operation_id = i_std_op_id;
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