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.CTO_CONFIG_ROUTING_PK dependencies on BOM_OPERATION_SEQUENCES_TEMP

Line 263: from bom_operation_sequences_temp -- 5336292

259: +--------------------------------------------------------*/
260:
261: cursor get_op_seq_num (pRtgId number) is
262: select distinct operation_seq_num,nvl(operation_type,1)
263: from bom_operation_sequences_temp -- 5336292
264: where config_routing_id=pRtgId; -- bugfix 3239267: replaced last_update_login
265:
266: -- 5336292
267: cursor bos_temp (pRtgId number ) is

Line 270: from bom_operation_sequences_temp

266: -- 5336292
267: cursor bos_temp (pRtgId number ) is
268: select operation_sequence_id,routing_sequence_id,operation_seq_num,config_routing_id,
269: operation_type,to_char(effectivity_date, 'DD-MON-YYYY HH24:MI:SS')
270: from bom_operation_sequences_temp
271: where config_routing_id=pRtgId;
272:
273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;

Line 273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;

269: operation_type,to_char(effectivity_date, 'DD-MON-YYYY HH24:MI:SS')
270: from bom_operation_sequences_temp
271: where config_routing_id=pRtgId;
272:
273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
275: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
276: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;

Line 274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;

270: from bom_operation_sequences_temp
271: where config_routing_id=pRtgId;
272:
273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
275: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
276: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;
278: d_op_effective_dt VARCHAR2(40);

Line 275: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;

271: where config_routing_id=pRtgId;
272:
273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
275: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
276: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;
278: d_op_effective_dt VARCHAR2(40);
279:

Line 276: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;

272:
273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
275: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
276: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;
278: d_op_effective_dt VARCHAR2(40);
279:
280:

Line 277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;

273: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
274: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
275: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
276: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
277: d_op_type bom_operation_sequences_temp.operation_type%TYPE;
278: d_op_effective_dt VARCHAR2(40);
279:
280:
281: v_program_id bom_cto_order_lines.program_id%type;

Line 696: -- Insert eligible rows into bom_operation_sequences_temp

692: /********************************************************************
693: NEW GFSI CODE 5336292
694: ********************************************************************/
695:
696: -- Insert eligible rows into bom_operation_sequences_temp
697: -- Note : We are not selecting distinct of ( operation_seq_num,operation_type,routing_sequence_id )
698: -- since bom_operation_sequences has operation_seq_num,operation_type,routing_sequence_id,eff_date
699: -- as unique combination key and eff_date is used in the where clause of select
700:

Line 706: insert into bom_operation_sequences_temp

702: l_batch_id := bom_import_pub.get_batchid;
703:
704: --1st insert
705: lStmtNum := 51;
706: insert into bom_operation_sequences_temp
707: (
708: operation_sequence_id,
709: routing_sequence_id,
710: config_routing_id, -- 5336292

Line 861: insert into bom_operation_sequences_temp

857: End if;
858:
859: --2nd insert
860: lStmtNum := 52;
861: insert into bom_operation_sequences_temp
862: (
863: operation_sequence_id,
864: routing_sequence_id,
865: config_routing_id, -- 5336292

Line 1064: from bom_operation_sequences_temp);

1060: --one-to-many BOM components to Rtg operations
1061: AND os1.option_dependent_flag = 1
1062: AND nvl(os1.operation_type,1) = 1
1063: and operation_sequence_id not in(select operation_sequence_id
1064: from bom_operation_sequences_temp);
1065:
1066: If PG_DEBUG <> 0 Then
1067: oe_debug_pub.add('Number of Model option dependent operations selected = '||sql%rowcount,1);
1068: End if;

Line 1072: insert into bom_operation_sequences_temp

1068: End if;
1069:
1070: --3rdnd insert
1071: lStmtNum := 53;
1072: insert into bom_operation_sequences_temp
1073: (
1074: operation_sequence_id,
1075: routing_sequence_id,
1076: config_routing_id, -- 5336292

Line 1252: from bom_operation_sequences_temp);

1248: )
1249: /* one-to-many BOM components to Rtg operations */
1250: AND nvl(os1.operation_type,1) = 1
1251: and operation_sequence_id not in(select operation_sequence_id
1252: from bom_operation_sequences_temp);
1253:
1254: If PG_DEBUG <> 0 Then
1255: oe_debug_pub.add('Number of Model mandatory independent operations selected = '||sql%rowcount,1);
1256: End if;

Line 1298: from bom_operation_sequences_temp -- 5336292

1294: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );
1295: END IF;
1296:
1297: select max(routing_sequence_id) into lmodrtgseqid
1298: from bom_operation_sequences_temp -- 5336292
1299: where operation_seq_num = lmodseqnum
1300: and nvl(operation_type,1)= lmodtyp
1301: and config_routing_id = lCfgRtgId -- bugfix 3239267: replaced last_update_login
1302: and last_update_date = glast_update_date; -- 3180827

Line 1308: update bom_operation_sequences_temp -- 5336292

1304: IF PG_DEBUG <> 0 THEN
1305: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lmodrtgseqid,2);
1306: END IF;
1307:
1308: update bom_operation_sequences_temp -- 5336292
1309: set config_routing_id = lmodnewCfgRtgId -- bugfix 3239267: replaced last_update_login
1310: where operation_seq_num = lmodseqnum
1311: and nvl(operation_type,1)= lmodtyp
1312: and routing_sequence_id=lmodrtgseqid

Line 1496: bom_operation_sequences_temp os1 -- 5336292

1492: sysdate,
1493: os1.x_coordinate, --bugfix 1765149
1494: os1.y_coordinate --bugfix 1765149
1495: from
1496: bom_operation_sequences_temp os1 -- 5336292
1497: where os1.config_routing_id = lmodnewcfgrtgid ; /*Bugfix 1935580 - change lCfgRtgId to lmodnewCfgRtgId */
1498: -- bugfix 3239267: replaced last_update_login
1499:
1500: IF PG_DEBUG <> 0 THEN

Line 1511: delete from bom_operation_sequences_temp

1507: +---------------------------------------------------------------*/
1508:
1509: -- 5336292 : Instead of update we will delete rows
1510: lStmtNum := 70;
1511: delete from bom_operation_sequences_temp
1512: where config_routing_id in (lCfgRtgId, lmodnewcfgrtgid);
1513:
1514: IF PG_DEBUG <> 0 THEN
1515: oe_debug_pub.add('create_routing_ml: ' || 'Deleted ' || sql%rowcount || ' rows from temp table',2);

Line 1546: insert into bom_operation_sequences_temp

1542: l_batch_id := bom_import_pub.get_batchid;
1543:
1544: --1st insert
1545: lStmtNum := 81;
1546: insert into bom_operation_sequences_temp
1547: ( operation_sequence_id,
1548: routing_sequence_id,
1549: config_routing_id, -- 5336292
1550: operation_seq_num,

Line 1710: insert into bom_operation_sequences_temp

1706:
1707: --2nd insert
1708: lStmtNum := 82;
1709:
1710: insert into bom_operation_sequences_temp
1711: ( operation_sequence_id,
1712: routing_sequence_id,
1713: config_routing_id, -- 5336292
1714: operation_seq_num,

Line 1908: from bom_operation_sequences_temp);

1904: /* one-to-many BOM components to Rtg operations */
1905: AND os1.option_dependent_flag = 1
1906: AND nvl(os1.operation_type,1) = 1
1907: and operation_sequence_id not in(select operation_sequence_id
1908: from bom_operation_sequences_temp);
1909:
1910:
1911: If PG_DEBUG <> 0 Then
1912: oe_debug_pub.add('Number of option class option dependent operations selected = '||sql%rowcount,1);

Line 1918: insert into bom_operation_sequences_temp

1914:
1915: --3rd insert
1916: lStmtNum := 83;
1917:
1918: insert into bom_operation_sequences_temp
1919: ( operation_sequence_id,
1920: routing_sequence_id,
1921: config_routing_id, -- 5336292
1922: operation_seq_num,

Line 2100: from bom_operation_sequences_temp);

2096: )
2097: /* one-to-many BOM components to Rtg operations */
2098: AND nvl(os1.operation_type,1) = 1
2099: and operation_sequence_id not in(select operation_sequence_id
2100: from bom_operation_sequences_temp);
2101:
2102: If PG_DEBUG <> 0 Then
2103: oe_debug_pub.add('Number of option class mandatory comps dependent operations selected = '||sql%rowcount,1);
2104: End if;

Line 2148: from bom_operation_sequences_temp -- 5336292

2144: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lopseqnum || ' Op Type : ' || loptyp ,2);
2145: END IF;
2146:
2147: select max(routing_sequence_id) into lrtgseqid
2148: from bom_operation_sequences_temp -- 5336292
2149: where operation_seq_num = lopseqnum
2150: and nvl(operation_type,1)= loptyp
2151: and config_routing_id=lCfgRtgId -- bugfix 3239267: replaced last_update_login
2152: and last_update_date = glast_update_date; -- 3180827

Line 2159: update bom_operation_sequences_temp -- 5336292

2155: IF PG_DEBUG <> 0 THEN
2156: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lrtgseqid,2);
2157: END IF;
2158:
2159: update bom_operation_sequences_temp -- 5336292
2160: set config_routing_id = lnewCfgRtgId -- bugfix 3239267: replaced last_update_login
2161: where operation_seq_num = lopseqnum
2162: and nvl(operation_type,1)= loptyp
2163: and routing_sequence_id=lrtgseqid

Line 2344: bom_operation_sequences_temp os1

2340: sysdate,
2341: os1.x_coordinate, --bugfix 1765149
2342: os1.y_coordinate --bugfix 1765149
2343: from
2344: bom_operation_sequences_temp os1
2345: where os1.config_routing_id = lnewCfgRtgId /*Bugfix 1906371 - change lCfgRtgId to lnewCfgRtgId */
2346: -- bugfix 3239267: replaced last_update_login
2347: and os1.operation_seq_num not in (
2348: select operation_seq_num

Line 2363: delete from bom_operation_sequences_temp

2359:
2360: -- New update of 3180827
2361: lStmtNum := 95;
2362: lStmtNum := 95;
2363: delete from bom_operation_sequences_temp
2364: where config_routing_id in (lCfgRtgId, lmodnewcfgrtgid);
2365:
2366: /*-------------------------------------------------------------------+
2367: Now update the process_op_seq_id and line_seq_id of