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_OPERATIONAL_ROUTINGS

Line 160: from bom_operational_routings bor,

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;
164:

Line 305: from bom_operational_routings bor,

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
308: and bos.operation_sequence_id = i_op_seq_id;
309: -- get enabled

Line 343: bom_operational_routings bor

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
346: and bor.assembly_item_id = wfs.primary_item_id
347: and nvl(bor.alternate_routing_designator, '########') = nvl(wfs.alternate_routing_designator, '########')

Line 442: bom_operational_routings bor

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
445: and bor.assembly_item_id = wfs.primary_item_id
446: and nvl(bor.alternate_routing_designator, '########') = nvl(wfs.alternate_routing_designator, '########')

Line 456: bom_operational_routings bor

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
459: and bor.assembly_item_id = wfs.primary_item_id
460: and nvl(bor.alternate_routing_designator, '@@@@@@@@') = nvl(wfs.alternate_routing_designator, '@@@@@@@@')

Line 1350: from bom_operational_routings

1346: x_returnStatus out nocopy varchar2) IS
1347:
1348: CURSOR routing_seq_no_alt(p_org_id NUMBER, p_assembly_id NUMBER) IS
1349: select common_routing_sequence_id
1350: from bom_operational_routings
1351: where organization_id = p_org_id
1352: and assembly_item_id = p_assembly_id;
1353:
1354: CURSOR routing_seq_alt(p_org_id NUMBER, p_assembly_id NUMBER, p_alt_desig VARCHAR2) IS

Line 1356: from bom_operational_routings

1352: and assembly_item_id = p_assembly_id;
1353:
1354: CURSOR routing_seq_alt(p_org_id NUMBER, p_assembly_id NUMBER, p_alt_desig VARCHAR2) IS
1355: select common_routing_sequence_id
1356: from bom_operational_routings
1357: where organization_id = p_org_id
1358: and assembly_item_id = p_assembly_id
1359: and alternate_routing_designator = p_alt_desig;
1360:

Line 2231: bom_operational_routings bor

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
2234: and bor.organization_id = p_org_id
2235: and bor.assembly_item_id = wfs.primary_item_id