APPS.BOMCUMYD dependencies on STANDARD

Line 403: BOM_STANDARD_OPERATIONS bso

399: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator,
400: bor.assembly_item_id
401: FROM BOM_OPERATIONAL_ROUTINGS bor,
402: BOM_OPERATION_SEQUENCES bos,
403: BOM_STANDARD_OPERATIONS bso
404: WHERE bor.ORGANIZATION_ID = current_org_id
405: AND bor.CFM_ROUTING_FLAG = 1
406: AND bor.LINE_ID = v_line
407: AND bso.OPERATION_CODE = v_operation_code

Line 408: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID

404: WHERE bor.ORGANIZATION_ID = current_org_id
405: AND bor.CFM_ROUTING_FLAG = 1
406: AND bor.LINE_ID = v_line
407: AND bso.OPERATION_CODE = v_operation_code
408: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID
409: AND bor.ROUTING_SEQUENCE_ID = bos.ROUTING_SEQUENCE_ID
410: AND bos.OPERATION_TYPE = l_op_type;
411:
412: CURSOR Cur_Flow_Rtg is

Line 431: BOM_STANDARD_OPERATIONS bso

427: CURSOR Cur_Item_Line_Op_Flow_Rtg (Item_id NUMBER, v_line NUMBER, v_operation_code VARCHAR2) is
428: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator
429: FROM BOM_OPERATIONAL_ROUTINGS bor,
430: BOM_OPERATION_SEQUENCES bos,
431: BOM_STANDARD_OPERATIONS bso
432: WHERE bor.ORGANIZATION_ID = current_org_id
433: AND bor.ASSEMBLY_ITEM_ID = Item_id
434: AND bor.CFM_ROUTING_FLAG = 1
435: AND bor.LINE_ID = v_line

Line 437: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID

433: AND bor.ASSEMBLY_ITEM_ID = Item_id
434: AND bor.CFM_ROUTING_FLAG = 1
435: AND bor.LINE_ID = v_line
436: AND bso.OPERATION_CODE = v_operation_code
437: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID
438: AND bor.ROUTING_SEQUENCE_ID = bos.ROUTING_SEQUENCE_ID
439: AND bos.OPERATION_TYPE = l_op_type;
440:
441: CURSOR Cur_Item_Flow_Rtg (Item_id NUMBER) is