APPS.FLM_EXECUTION_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 86: from bom_operational_routings bor,

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

Line 223: from bom_operational_routings bor,

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

Line 258: bom_operational_routings bor

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

Line 272: bom_operational_routings bor

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

Line 1130: from bom_operational_routings

1126: x_returnStatus out nocopy varchar2) IS
1127:
1128: CURSOR routing_seq_no_alt(p_org_id NUMBER, p_assembly_id NUMBER) IS
1129: select common_routing_sequence_id
1130: from bom_operational_routings
1131: where organization_id = p_org_id
1132: and assembly_item_id = p_assembly_id;
1133:
1134: CURSOR routing_seq_alt(p_org_id NUMBER, p_assembly_id NUMBER, p_alt_desig VARCHAR2) IS

Line 1136: from bom_operational_routings

1132: and assembly_item_id = p_assembly_id;
1133:
1134: CURSOR routing_seq_alt(p_org_id NUMBER, p_assembly_id NUMBER, p_alt_desig VARCHAR2) IS
1135: select common_routing_sequence_id
1136: from bom_operational_routings
1137: where organization_id = p_org_id
1138: and assembly_item_id = p_assembly_id
1139: and alternate_routing_designator = p_alt_desig;
1140: