DBA Data[Home] [Help]

APPS.BOMCUMYD dependencies on BOM_STANDARD_OPERATIONS

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 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