APPS.BOMCUMYD dependencies on BOM_OPERATIONAL_ROUTINGS

Line 45: FROM bom_operational_routings

41: AND organization_id = current_org_id;
42:
43: CURSOR Cur_Rtg(Item_Id NUMBER) IS
44: SELECT routing_sequence_id,alternate_routing_designator
45: FROM bom_operational_routings
46: WHERE assembly_item_id = Item_Id
47: AND cfm_routing_flag = 3
48: AND organization_id = current_org_id;
49:

Line 187: BOM_OPERATIONAL_ROUTINGS bor

183: BOM_CALC_OP_TIMES_PK.calculate_operation_times(org_id, rtg_seq_id);
184:
185: /*** Updation of TPCT in the Master items Table *****/
186: SELECT TOTAL_PRODUCT_CYCLE_TIME into l_tpct FROM
187: BOM_OPERATIONAL_ROUTINGS bor
188: WHERE bor.ROUTING_SEQUENCE_ID = rtg_seq_id
189: AND bor.ORGANIZATION_ID = org_id
190: AND bor.ASSEMBLY_ITEM_ID = item_id;
191:

Line 351: FROM BOM_OPERATIONAL_ROUTINGS bor

347:
348: CURSOR Cur_Line_Flow_Rtg (v_line NUMBER) is
349: SELECT routing_sequence_id, alternate_routing_designator,
350: assembly_item_id
351: FROM BOM_OPERATIONAL_ROUTINGS bor
352: WHERE bor.ORGANIZATION_ID = current_org_id
353: AND bor.CFM_ROUTING_FLAG = 1
354: AND bor.LINE_ID = v_line;
355:

Line 359: FROM BOM_OPERATIONAL_ROUTINGS bor,

355:
356: CURSOR Cur_Line_Op_Flow_Rtg (v_line NUMBER, v_operation_code VARCHAR2) is
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

Line 373: FROM BOM_OPERATIONAL_ROUTINGS bor

369:
370: CURSOR Cur_Flow_Rtg is
371: SELECT routing_sequence_id, alternate_routing_designator,
372: assembly_item_id
373: FROM BOM_OPERATIONAL_ROUTINGS bor
374: WHERE bor.ORGANIZATION_ID = current_org_id
375: AND bor.CFM_ROUTING_FLAG = 1;
376:
377: CURSOR Cur_Item_Line_Flow_Rtg (Item_id NUMBER, v_line NUMBER) is

Line 379: FROM BOM_OPERATIONAL_ROUTINGS bor

375: AND bor.CFM_ROUTING_FLAG = 1;
376:
377: CURSOR Cur_Item_Line_Flow_Rtg (Item_id NUMBER, v_line NUMBER) is
378: SELECT routing_sequence_id, alternate_routing_designator
379: FROM BOM_OPERATIONAL_ROUTINGS bor
380: WHERE bor.ORGANIZATION_ID = current_org_id
381: AND bor.ASSEMBLY_ITEM_ID = Item_id
382: AND bor.CFM_ROUTING_FLAG = 1
383: AND bor.LINE_ID = v_line;

Line 387: FROM BOM_OPERATIONAL_ROUTINGS bor,

383: AND bor.LINE_ID = v_line;
384:
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

Line 401: FROM BOM_OPERATIONAL_ROUTINGS bor

397: AND bos.OPERATION_TYPE = l_op_type;
398:
399: CURSOR Cur_Item_Flow_Rtg (Item_id NUMBER) is
400: SELECT routing_sequence_id, alternate_routing_designator
401: FROM BOM_OPERATIONAL_ROUTINGS bor
402: WHERE bor.ORGANIZATION_ID = current_org_id
403: AND bor.ASSEMBLY_ITEM_ID = Item_id
404: AND bor.CFM_ROUTING_FLAG = 1;
405: