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 STANDARD

Line 28: AND STANDARD_OPERATION_ID = l_operation_id;

24: SELECT data_entry_mode
25: FROM FLM_EXE_PREFERENCES
26: WHERE ORGANIZATION_ID = l_org_id
27: AND LINE_ID = l_line_id
28: AND STANDARD_OPERATION_ID = l_operation_id;
29:
30: CURSOR c_dem_line IS
31: SELECT data_entry_mode
32: FROM FLM_EXE_PREFERENCES

Line 35: AND STANDARD_OPERATION_ID IS NULL;

31: SELECT data_entry_mode
32: FROM FLM_EXE_PREFERENCES
33: WHERE ORGANIZATION_ID = l_org_id
34: AND LINE_ID = l_line_id
35: AND STANDARD_OPERATION_ID IS NULL;
36:
37: CURSOR c_dem_org IS
38: SELECT data_entry_mode
39: FROM FLM_EXE_PREFERENCES

Line 42: AND STANDARD_OPERATION_ID IS NULL;

38: SELECT data_entry_mode
39: FROM FLM_EXE_PREFERENCES
40: WHERE ORGANIZATION_ID = l_org_id
41: AND LINE_ID IS NULL
42: AND STANDARD_OPERATION_ID IS NULL;
43:
44: BEGIN
45: l_org_id := p_organization_id;
46: l_line_id := p_line_id;

Line 97: AND STANDARD_OPERATION_ID = l_operation_id;

93: SELECT VIEW_ALL_SCHEDULES
94: FROM FLM_EXE_PREFERENCES
95: WHERE ORGANIZATION_ID = l_org_id
96: AND LINE_ID = l_line_id
97: AND STANDARD_OPERATION_ID = l_operation_id;
98:
99: CURSOR c_view_all_line IS
100: SELECT VIEW_ALL_SCHEDULES
101: FROM FLM_EXE_PREFERENCES

Line 104: AND STANDARD_OPERATION_ID IS NULL;

100: SELECT VIEW_ALL_SCHEDULES
101: FROM FLM_EXE_PREFERENCES
102: WHERE ORGANIZATION_ID = l_org_id
103: AND LINE_ID = l_line_id
104: AND STANDARD_OPERATION_ID IS NULL;
105:
106: CURSOR c_view_all_org IS
107: SELECT VIEW_ALL_SCHEDULES
108: FROM FLM_EXE_PREFERENCES

Line 111: AND STANDARD_OPERATION_ID IS NULL;

107: SELECT VIEW_ALL_SCHEDULES
108: FROM FLM_EXE_PREFERENCES
109: WHERE ORGANIZATION_ID = l_org_id
110: AND LINE_ID IS NULL
111: AND STANDARD_OPERATION_ID IS NULL;
112:
113: BEGIN
114: l_org_id := p_organization_id;
115: l_line_id := p_line_id;

Line 159: bos.standard_operation_id

155:
156: CURSOR c_rtg IS
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;

Line 170: l_std_op_id := c_rtg_rec.standard_operation_id;

166:
167: FOR c_rtg_rec in c_rtg LOOP
168: l_org_id := c_rtg_rec.organization_id;
169: l_line_id := c_rtg_rec.line_id;
170: l_std_op_id := c_rtg_rec.standard_operation_id;
171: END LOOP;
172: --Bug 13812197: caching the value for view_all_schedules parameter
173: IF (G_VIEW_ALL_SCHEDULES = 'U') then
174: l_view_all_sch := get_view_all_schedules(l_org_id, l_line_id, l_std_op_id);

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

222: FLM_EXE_PREFERENCES
223: WHERE
224: ORGANIZATION_ID = l_org_id AND
225: NVL(LINE_ID,-1) = NVL(l_line_id,-1) AND
226: NVL(STANDARD_OPERATION_ID,-1) = nvl(l_operation_id,-1);
227:
228: BEGIN
229:
230: --SAVEPOINT get_workstation_enabled;

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

299: l_msg_cnt NUMBER;
300: l_msg VARCHAR2(2000);
301: BEGIN
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

Line 350: and bos.standard_operation_id = i_std_op_id;

346: and bor.assembly_item_id = wfs.primary_item_id
347: and nvl(bor.alternate_routing_designator, '########') = nvl(wfs.alternate_routing_designator, '########')
348: and bor.common_routing_sequence_id = bos.routing_sequence_id
349: and bos.operation_type = 3 -- line operation
350: and bos.standard_operation_id = i_std_op_id;
351:
352: select count(*)
353: into l_cnt
354: from flm_exe_operations

Line 437: -- standard operation.

433: l_line_id NUMBER := 0;
434:
435: -- Cursor to find the sequence id of the operation in the routing
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,

Line 449: and bos.standard_operation_id = i_std_op_id;

445: and bor.assembly_item_id = wfs.primary_item_id
446: and nvl(bor.alternate_routing_designator, '########') = nvl(wfs.alternate_routing_designator, '########')
447: and bor.common_routing_sequence_id = bos.routing_sequence_id
448: and bos.operation_type = 3 -- line operation
449: and bos.standard_operation_id = i_std_op_id;
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

Line 2224: -- standard operation.

2220: l_rtg_rev_date DATE;
2221:
2222: -- Cursor to find the sequence id of the operation in the routing
2223: -- corresponding to the schedule that references the specified
2224: -- standard operation.
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

Line 2240: and bos.standard_operation_id = p_std_op_id;

2236: and nvl(bor.alternate_routing_designator, '########') =
2237: nvl(wfs.alternate_routing_designator, '########')
2238: and bor.common_routing_sequence_id = bos.routing_sequence_id
2239: and bos.operation_type = 3 -- line operation
2240: and bos.standard_operation_id = p_std_op_id;
2241:
2242:
2243: CURSOR event_exist_csr IS
2244: select 'Y' as event_exist