eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMCUMYD dependencies on BOM_OPERATIONAL_ROUTINGS

Line 46: FROM bom_operational_routings

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

Line 93: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

89: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
90: end if;
91: --changes for bug 9676295 begin
92: begin
93: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings
94: where common_routing_sequence_id <> routing_sequence_id and routing_sequence_id = C1.routing_sequence_id;
95: exception
96: when no_data_found then
97: l_routing_sequence_id := C1.routing_sequence_id;

Line 122: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

118: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
119: end if;
120: --changes for bug 9676295 begin
121: begin
122: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings
123: where common_routing_sequence_id <> routing_sequence_id and routing_sequence_id = C1.routing_sequence_id;
124: exception
125: when no_data_found then
126: l_routing_sequence_id := C1.routing_sequence_id;

Line 152: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

148: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
149: end if;
150: --changes for bug 9676295 begin
151: begin
152: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings
153: where common_routing_sequence_id <> routing_sequence_id and routing_sequence_id = C1.routing_sequence_id;
154: exception
155: when no_data_found then
156: l_routing_sequence_id := C1.routing_sequence_id;

Line 180: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

176: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
177: end if;
178: --changes for bug 9676295 begin
179: begin
180: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings
181: where common_routing_sequence_id <> routing_sequence_id and routing_sequence_id = C1.routing_sequence_id;
182: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing common routing for item....' || Item_Name || ' with common routing sequence id ' || l_routing_sequence_id);
183: exception
184: when no_data_found then

Line 229: BOM_OPERATIONAL_ROUTINGS bor

225: BOM_CALC_OP_TIMES_PK.calculate_operation_times(org_id, rtg_seq_id);
226:
227: /*** Updation of TPCT in the Master items Table *****/
228: SELECT TOTAL_PRODUCT_CYCLE_TIME into l_tpct FROM
229: BOM_OPERATIONAL_ROUTINGS bor
230: WHERE bor.ROUTING_SEQUENCE_ID = rtg_seq_id
231: AND bor.ORGANIZATION_ID = org_id
232: AND bor.ASSEMBLY_ITEM_ID = item_id;
233:

Line 393: FROM BOM_OPERATIONAL_ROUTINGS bor

389:
390: CURSOR Cur_Line_Flow_Rtg (v_line NUMBER) is
391: SELECT routing_sequence_id, alternate_routing_designator,
392: assembly_item_id
393: FROM BOM_OPERATIONAL_ROUTINGS bor
394: WHERE bor.ORGANIZATION_ID = current_org_id
395: AND bor.CFM_ROUTING_FLAG = 1
396: AND bor.LINE_ID = v_line;
397:

Line 401: FROM BOM_OPERATIONAL_ROUTINGS bor,

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

Line 415: FROM BOM_OPERATIONAL_ROUTINGS bor

411:
412: CURSOR Cur_Flow_Rtg is
413: SELECT routing_sequence_id, alternate_routing_designator,
414: assembly_item_id
415: FROM BOM_OPERATIONAL_ROUTINGS bor
416: WHERE bor.ORGANIZATION_ID = current_org_id
417: AND bor.CFM_ROUTING_FLAG = 1;
418:
419: CURSOR Cur_Item_Line_Flow_Rtg (Item_id NUMBER, v_line NUMBER) is

Line 421: FROM BOM_OPERATIONAL_ROUTINGS bor

417: AND bor.CFM_ROUTING_FLAG = 1;
418:
419: CURSOR Cur_Item_Line_Flow_Rtg (Item_id NUMBER, v_line NUMBER) is
420: SELECT routing_sequence_id, alternate_routing_designator
421: FROM BOM_OPERATIONAL_ROUTINGS bor
422: WHERE bor.ORGANIZATION_ID = current_org_id
423: AND bor.ASSEMBLY_ITEM_ID = Item_id
424: AND bor.CFM_ROUTING_FLAG = 1
425: AND bor.LINE_ID = v_line;

Line 429: FROM BOM_OPERATIONAL_ROUTINGS bor,

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

Line 443: FROM BOM_OPERATIONAL_ROUTINGS bor

439: AND bos.OPERATION_TYPE = l_op_type;
440:
441: CURSOR Cur_Item_Flow_Rtg (Item_id NUMBER) is
442: SELECT routing_sequence_id, alternate_routing_designator
443: FROM BOM_OPERATIONAL_ROUTINGS bor
444: WHERE bor.ORGANIZATION_ID = current_org_id
445: AND bor.ASSEMBLY_ITEM_ID = Item_id
446: AND bor.CFM_ROUTING_FLAG = 1;
447: