APPS.BOM_DEFAULT_OP_SEQ dependencies on BOM_OPERATIONAL_ROUTINGS

Line 72: FROM bom_operational_routings bor

68: , p_organization_id NUMBER
69: , p_alternate_routing_code VARCHAR2 )
70: IS
71: SELECT routing_sequence_id
72: FROM bom_operational_routings bor
73: WHERE bor.assembly_item_id = p_revised_item_id
74: AND bor.organization_id = p_organization_id
75: AND NVL(bor.alternate_routing_designator, FND_API.G_MISS_CHAR) =
76: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR);

Line 80: SELECT Bom_Operational_Routings_S.NEXTVAL Rtg_Seq_Id

76: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR);
77:
78:
79: CURSOR l_rtg_seq_csr IS
80: SELECT Bom_Operational_Routings_S.NEXTVAL Rtg_Seq_Id
81: FROM SYS.DUAL ;
82:
83: l_routing_sequence_id NUMBER;
84:

Line 470: , bom_operational_routings bor

466: , bso.show_scrap_code
467: , bso.show_lot_attrib
468: , bso.track_multiple_res_usage_dates -- End of MES Changes
469: FROM BOM_STANDARD_OPERATIONS bso
470: , bom_operational_routings bor
471: WHERE NVL(bso.operation_type,1 )
472: = DECODE(p_op_type, FND_API.G_MISS_NUM, 1
473: , NVL(p_op_type, 1))
474: AND NVL(bso.line_id, FND_API.G_MISS_NUM)