APPS.BOMCUMYD dependencies on STANDARD

Line 361: BOM_STANDARD_OPERATIONS bso

357: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator,
358: bor.assembly_item_id
359: FROM BOM_OPERATIONAL_ROUTINGS bor,
360: BOM_OPERATION_SEQUENCES bos,
361: BOM_STANDARD_OPERATIONS bso
362: WHERE bor.ORGANIZATION_ID = current_org_id
363: AND bor.CFM_ROUTING_FLAG = 1
364: AND bor.LINE_ID = v_line
365: AND bso.OPERATION_CODE = v_operation_code

Line 366: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID

362: WHERE bor.ORGANIZATION_ID = current_org_id
363: AND bor.CFM_ROUTING_FLAG = 1
364: AND bor.LINE_ID = v_line
365: AND bso.OPERATION_CODE = v_operation_code
366: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID
367: AND bor.ROUTING_SEQUENCE_ID = bos.ROUTING_SEQUENCE_ID
368: AND bos.OPERATION_TYPE = l_op_type;
369:
370: CURSOR Cur_Flow_Rtg is

Line 389: BOM_STANDARD_OPERATIONS bso

385: CURSOR Cur_Item_Line_Op_Flow_Rtg (Item_id NUMBER, v_line NUMBER, v_operation_code VARCHAR2) is
386: SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator
387: FROM BOM_OPERATIONAL_ROUTINGS bor,
388: BOM_OPERATION_SEQUENCES bos,
389: BOM_STANDARD_OPERATIONS bso
390: WHERE bor.ORGANIZATION_ID = current_org_id
391: AND bor.ASSEMBLY_ITEM_ID = Item_id
392: AND bor.CFM_ROUTING_FLAG = 1
393: AND bor.LINE_ID = v_line

Line 395: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID

391: AND bor.ASSEMBLY_ITEM_ID = Item_id
392: AND bor.CFM_ROUTING_FLAG = 1
393: AND bor.LINE_ID = v_line
394: AND bso.OPERATION_CODE = v_operation_code
395: AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID
396: AND bor.ROUTING_SEQUENCE_ID = bos.ROUTING_SEQUENCE_ID
397: AND bos.OPERATION_TYPE = l_op_type;
398:
399: CURSOR Cur_Item_Flow_Rtg (Item_id NUMBER) is