[Home] [Help]
34: cursor l_assy_csr(P_RtgSeqId number) is
35: Select assembly_item_id,
36: organization_id,
37: alternate_routing_designator
38: From bom_operational_routings
39: Where routing_sequence_id = P_RtgSeqId;
40: cursor l_parameter_csr(P_Code varchar2) is
41: Select organization_id
42: From mtl_parameters
48: and department_code = P_Code;
49: cursor l_routing_csr(P_AssyItemId number, P_OrgId number,
50: P_Alternate varchar2) is
51: select routing_sequence_id
52: from bom_operational_routings
53: where organization_id = P_OrgId
54: and assembly_item_id = P_AssyItemId
55: and nvl(alternate_routing_designator, 'Primary Alternate') =
56: nvl(P_Alternate, 'Primary Alternate');
58: cursor l_StdOp_csr(P_Code varchar2, P_OpType number,
59: P_RtgSeqId number) is
60: select bso.standard_operation_id
61: from bom_standard_operations bso,
62: bom_operational_routings bor
63: where bso.organization_id = bor.organization_id
64: and nvl(bso.line_id, -1) = nvl(bor.line_id, -1)
65: and nvl(bso.operation_type, g_event) =
66: nvl(P_OpType, g_event)
280: Select 'x' dummy
281: From dual
282: Where not exists(
283: select null
284: from bom_operational_routings bor
285: where bor.routing_sequence_id = P_RtgSeqId);
286: cursor l_noncfm_csr (P_RtgSeqId number) is
287: Select 'x' dummy
288: From bom_operational_routings bor
284: from bom_operational_routings bor
285: where bor.routing_sequence_id = P_RtgSeqId);
286: cursor l_noncfm_csr (P_RtgSeqId number) is
287: Select 'x' dummy
288: From bom_operational_routings bor
289: Where bor.routing_sequence_id = P_RtgSeqId
290: And nvl(bor.cfm_routing_flag, 2) = 2;
291: cursor l_lbr_csr (P_RtgSeqId number) is
292: Select 'x' dummy
289: Where bor.routing_sequence_id = P_RtgSeqId
290: And nvl(bor.cfm_routing_flag, 2) = 2;
291: cursor l_lbr_csr (P_RtgSeqId number) is
292: Select 'x' dummy
293: From bom_operational_routings bor
294: Where bor.routing_sequence_id = P_RtgSeqId
295: And nvl(bor.cfm_routing_flag,2) = 3;
296: cursor l_OtherOps_csr(P_RtgSeqId number, P_OpSeqId number,
297: P_OpSeqNum number, P_OpType number, P_EffDate date,
312: )
313: );
314: cursor l_common_csr(P_RtgSeqId number) is
315: select 'Is pointing to a common' dummy
316: from bom_operational_routings
317: where routing_sequence_id = P_RtgSeqId
318: and common_routing_sequence_id <>
319: routing_sequence_id;
320: l_PrevStdOp number := null;
369: bso.ATTRIBUTE14,
370: bso.ATTRIBUTE15,
371: bso.OPERATION_YIELD_ENABLED
372: from bom_standard_operations bso,
373: bom_operational_routings bor
374: where bso.standard_operation_id = P_StdOpId
375: and bor.routing_sequence_id = P_RtgSeqId
376: and bso.organization_id = bor.organization_id
377: and nvl(bso.line_id, -1) = nvl(bor.line_id, -1)
390: from dual
391: where not exists(
392: Select null
393: from bom_departments bd,
394: bom_operational_routings bor
395: where bd.organization_id = bor.organization_id
396: and bor.routing_sequence_id = P_RtgSeqId
397: and bd.department_id = P_DeptId
398: and nvl(bd.disable_date, P_EffDate+1) > P_EffDate
1696: WHERE bic.OPERATION_SEQ_NUM = l_operation_rec.new_operation_seq_num
1697: and bic.BILL_SEQUENCE_ID =
1698: (select bom.BILL_SEQUENCE_ID
1699: from BOM_BILL_OF_MATERIALS bom,
1700: BOM_OPERATIONAL_ROUTINGS bor
1701: where bor.routing_sequence_id = l_operation_rec.routing_sequence_id
1702: and nvl(bor.alternate_routing_designator,'NONE') =
1703: nvl(bom.ALTERNATE_BOM_DESIGNATOR,'NONE')
1704: and bom.ASSEMBLY_ITEM_ID = bor.assembly_item_id
1773: bor.assembly_item_id,
1774: bor.organization_id,
1775: bor.alternate_routing_designator,
1776: bor.routing_type
1777: From bom_operational_routings bor,
1778: bom_operation_sequences bos
1779: Where bor.routing_sequence_id = bos.routing_sequence_id
1780: and (bos.operation_sequence_id = P_OpSeqId
1781: Or