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.MSC_CL_PRE_PROCESS dependencies on MSC_LOCAL_ID_MISC

Line 2781: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_MISC', v_instance_id, -1);

2777:
2778: END IF;
2779:
2780: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SETUP', v_instance_id, -1);
2781: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_MISC', v_instance_id, -1);
2782:
2783:
2784: EXCEPTION
2785: when others then

Line 19538: ||' FROM msc_local_id_misc'

19534: v_sql_stmt := 10;
19535: lv_sql_stmt :=
19536: ' UPDATE msc_st_category_sets'
19537: ||' SET sr_category_set_id = (SELECT local_id'
19538: ||' FROM msc_local_id_misc'
19539: ||' WHERE char1 = sr_instance_code'
19540: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||')='
19541: ||' NVL(company_name,'||''''||NULL_CHAR||''''||')'
19542: ||' AND char3 = category_set_name'

Line 19579: INSERT INTO msc_local_id_misc

19575: WHERE rowid = lb_rowid(j);
19576:
19577: v_sql_stmt := 12;
19578: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
19579: INSERT INTO msc_local_id_misc
19580: (local_id,
19581: st_transaction_id,
19582: instance_id,
19583: entity_name,

Line 22837: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '

22833: -- update ABC_CLASS_ID where it exists in the planning system
22834: v_sql_stmt := 14;
22835: lv_sql_stmt :=
22836: ' UPDATE msc_st_system_items msi'
22837: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
22838: ||' WHERE mac.char1 = msi.sr_instance_code'
22839: ||' AND mac.char3 = msi.organization_code '
22840: ||' AND mac.char4 = msi.abc_class_name '
22841: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''

Line 22868: INSERT INTO msc_local_id_misc

22864: WHERE rowid = lb_rowid_abc(j);
22865:
22866:
22867: FORALL j IN lb_rowid_abc.FIRST..lb_rowid_abc.LAST
22868: INSERT INTO msc_local_id_misc
22869: (local_id,
22870: st_transaction_id,
22871: instance_id,
22872: entity_name,

Line 22906: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '

22902: -- update ABC_CLASS_ID for ABC_CLASS_NAME for which we have just populated the local id
22903: v_sql_stmt := 15;
22904: lv_sql_stmt :=
22905: ' UPDATE msc_st_system_items msi'
22906: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
22907: ||' WHERE mac.char1 = msi.sr_instance_code'
22908: ||' AND mac.char3 = msi.organization_code '
22909: ||' AND mac.char4 = msi.abc_class_name '
22910: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''

Line 27372: ||' FROM msc_local_id_misc'

27368: v_sql_stmt := 07;
27369: lv_sql_stmt :=
27370: 'UPDATE msc_st_item_categories '
27371: ||' SET sr_category_set_id = (SELECT local_id'
27372: ||' FROM msc_local_id_misc'
27373: ||' WHERE char1 = sr_instance_code'
27374: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
27375: ||' NVL(company_name,'||''''||NULL_CHAR||''''||') '
27376: ||' AND char3 = category_set_name'

Line 27424: ||' FROM msc_local_id_misc'

27420: v_sql_stmt := 09;
27421: lv_sql_stmt :=
27422: 'UPDATE msc_st_item_categories '
27423: ||' SET sr_category_id = (SELECT local_id '
27424: ||' FROM msc_local_id_misc'
27425: ||' WHERE char1 = sr_instance_code'
27426: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
27427: ||' NVL(company_name,'||''''||NULL_CHAR||''''||') '
27428: ||' AND char3 = category_name'

Line 27466: INSERT INTO msc_local_id_misc

27462: WHERE rowid = lb_rowid(j);
27463:
27464: v_sql_stmt := 11;
27465: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27466: INSERT INTO msc_local_id_misc
27467: (local_id,
27468: st_transaction_id,
27469: instance_id,
27470: entity_name,

Line 27511: ||' FROM msc_local_id_misc'

27507: v_sql_stmt := 09;
27508: lv_sql_stmt :=
27509: 'UPDATE msc_st_item_categories '
27510: ||' SET sr_category_id = (SELECT local_id '
27511: ||' FROM msc_local_id_misc'
27512: ||' WHERE char1 = sr_instance_code'
27513: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
27514: ||' NVL(company_name,'||''''||NULL_CHAR||''''||') '
27515: ||' AND char3 = category_name'

Line 28353: ||' SET category_set_id = ( SELECT local_id FROM msc_local_id_misc mlim'

28349: v_sql_stmt :=14;
28350:
28351: lv_sql_stmt :=
28352: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28353: ||' SET category_set_id = ( SELECT local_id FROM msc_local_id_misc mlim'
28354: ||' WHERE entity_name = ''SR_CATEGORY_SET_ID'' '
28355: ||' AND instance_id = '||v_instance_id
28356: ||' AND mlim.char1 = msis.sr_instance_code'
28357: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 28377: ||' SET category_id = ( SELECT local_id FROM msc_local_id_misc mlim'

28373: v_sql_stmt :=15;
28374:
28375: lv_sql_stmt :=
28376: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28377: ||' SET category_id = ( SELECT local_id FROM msc_local_id_misc mlim'
28378: ||' WHERE entity_name = ''SR_CATEGORY_ID'' '
28379: ||' AND instance_id = '||v_instance_id
28380: ||' AND mlim.char1 = msis.sr_instance_code'
28381: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 28641: ||' FROM msc_local_id_misc mlim'

28637:
28638: lv_sql_stmt:=
28639: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28640: ||' SET sourcing_rule_id = (SELECT local_id '
28641: ||' FROM msc_local_id_misc mlim'
28642: ||' WHERE mlim.entity_name= ''SOURCING_RULE_ID'' '
28643: ||' AND mlim.char1 = msis.sr_instance_code'
28644: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
28645: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 28663: ||' FROM msc_local_id_misc mlim'

28659: v_sql_stmt := 19;
28660: lv_sql_stmt:=
28661: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28662: ||' SET assignment_set_id = (SELECT local_id'
28663: ||' FROM msc_local_id_misc mlim'
28664: ||' WHERE mlim.entity_name= ''ASSIGNMENT_SET_ID'' '
28665: ||' AND mlim.char1 = msis.sr_instance_code'
28666: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
28667: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 28685: ||' FROM msc_local_id_misc mlim'

28681:
28682: lv_sql_stmt:=
28683: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28684: ||' SET sr_receipt_id = (SELECT local_id'
28685: ||' FROM msc_local_id_misc mlim'
28686: ||' WHERE mlim.entity_name= ''SR_RECEIPT_ID'' '
28687: ||' AND mlim.char1 = msis.sr_instance_code'
28688: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
28689: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 28715: ||' FROM msc_local_id_misc mlim'

28711:
28712: lv_sql_stmt:=
28713: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28714: ||' SET sr_source_id = (SELECT local_id'
28715: ||' FROM msc_local_id_misc mlim'
28716: ||' WHERE mlim.entity_name= ''SR_SOURCE_ID'' '
28717: ||' AND mlim.char1 = msis.sr_instance_code'
28718: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
28719: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 28752: ||' FROM msc_local_id_misc mlim'

28748:
28749: lv_sql_stmt:=
28750: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28751: ||' SET assignment_id = (SELECT local_id '
28752: ||' FROM msc_local_id_misc mlim'
28753: ||' WHERE mlim.entity_name= ''ASSIGNMENT_ID'' '
28754: ||' AND mlim.instance_id = '||v_instance_id
28755: ||' AND mlim.char1 = msis.sr_instance_code'
28756: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 28839: INSERT INTO msc_local_id_misc

28835: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28836:
28837: -- Insert into the LID table
28838:
28839: INSERT INTO msc_local_id_misc
28840: (local_id,
28841: st_transaction_id,
28842: instance_id,
28843: entity_name,

Line 28893: ||' FROM msc_local_id_misc mlim'

28889:
28890: lv_sql_stmt:=
28891: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28892: ||' SET sourcing_rule_id = (SELECT local_id '
28893: ||' FROM msc_local_id_misc mlim'
28894: ||' WHERE mlim.entity_name= ''SOURCING_RULE_ID'' '
28895: ||' AND mlim.char1 = msis.sr_instance_code'
28896: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
28897: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 28933: INSERT INTO msc_local_id_misc

28929: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28930:
28931: -- Insert into the LID table
28932:
28933: INSERT INTO msc_local_id_misc
28934: (local_id,
28935: st_transaction_id,
28936: instance_id,
28937: entity_name,

Line 28972: ||' FROM msc_local_id_misc mlim'

28968: v_sql_stmt := 29;
28969: lv_sql_stmt:=
28970: 'UPDATE MSC_ST_ITEM_SOURCING msis'
28971: ||' SET assignment_set_id = (SELECT local_id'
28972: ||' FROM msc_local_id_misc mlim'
28973: ||' WHERE mlim.entity_name= ''ASSIGNMENT_SET_ID'' '
28974: ||' AND mlim.char1 = msis.sr_instance_code'
28975: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
28976: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 29008: INSERT INTO msc_local_id_misc

29004: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29005:
29006: -- Insert into the LID table
29007:
29008: INSERT INTO msc_local_id_misc
29009: (local_id,
29010: st_transaction_id,
29011: instance_id,
29012: entity_name,

Line 29073: ||' FROM msc_local_id_misc mlim'

29069:
29070: lv_sql_stmt:=
29071: 'UPDATE MSC_ST_ITEM_SOURCING msis'
29072: ||' SET sr_receipt_id = (SELECT local_id'
29073: ||' FROM msc_local_id_misc mlim'
29074: ||' WHERE mlim.entity_name= ''SR_RECEIPT_ID'' '
29075: ||' AND mlim.char1 = msis.sr_instance_code'
29076: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
29077: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 29118: INSERT INTO msc_local_id_misc

29114: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29115:
29116: -- Insert into the LID table
29117:
29118: INSERT INTO msc_local_id_misc
29119: (local_id,
29120: st_transaction_id,
29121: instance_id,
29122: entity_name,

Line 29198: ||' FROM msc_local_id_misc mlim'

29194:
29195: lv_sql_stmt:=
29196: 'UPDATE MSC_ST_ITEM_SOURCING msis'
29197: ||' SET sr_source_id = (SELECT local_id'
29198: ||' FROM msc_local_id_misc mlim'
29199: ||' WHERE mlim.entity_name= ''SR_SOURCE_ID'' '
29200: ||' AND mlim.char1 = msis.sr_instance_code'
29201: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
29202: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 29251: INSERT INTO msc_local_id_misc

29247:
29248: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29249: -- Insert into the LID table
29250:
29251: INSERT INTO msc_local_id_misc
29252: (local_id,
29253: st_transaction_id,
29254: instance_id,
29255: entity_name,

Line 29309: ||' FROM msc_local_id_misc mlim'

29305:
29306: lv_sql_stmt:=
29307: 'UPDATE MSC_ST_ITEM_SOURCING msis'
29308: ||' SET assignment_id = (SELECT local_id '
29309: ||' FROM msc_local_id_misc mlim'
29310: ||' WHERE mlim.entity_name= ''ASSIGNMENT_ID'' '
29311: ||' AND mlim.instance_id = '||v_instance_id
29312: ||' AND mlim.char1 = msis.sr_instance_code'
29313: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 30062: ||' FROM msc_local_id_misc mlim'

30058:
30059: lv_sql_stmt :=
30060: 'UPDATE msc_st_project_tasks mstp'
30061: ||' SET costing_group_id = ( SELECT local_id '
30062: ||' FROM msc_local_id_misc mlim'
30063: ||' WHERE mlim.char1 = mstp.sr_instance_code'
30064: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
30065: ||' = NVL(mstp.company_name,'||''''||NULL_CHAR||''''||') '
30066: /* ||' AND mlim.char3 = mstp.organization_code'*/

Line 30115: INSERT INTO msc_local_id_misc

30111:
30112: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30113: -- Insert into the LID table with the user defined key
30114:
30115: INSERT INTO msc_local_id_misc
30116: (local_id,
30117: st_transaction_id,
30118: instance_id,
30119: entity_name,

Line 30159: ||' FROM msc_local_id_misc mlim'

30155:
30156: lv_sql_stmt :=
30157: 'UPDATE msc_st_project_tasks mstp'
30158: ||' SET costing_group_id = ( SELECT local_id '
30159: ||' FROM msc_local_id_misc mlim'
30160: ||' WHERE mlim.char1 = mstp.sr_instance_code'
30161: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
30162: ||' = NVL(mstp.company_name,'||''''||NULL_CHAR||''''||') '
30163: /* ||' AND mlim.char3 = mstp.organization_code'*/

Line 30200: INSERT INTO msc_local_id_misc

30196:
30197: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30198:
30199: -- Insert into the LID table with the user defined key
30200: INSERT INTO msc_local_id_misc
30201: (local_id,
30202: st_transaction_id,
30203: instance_id,
30204: entity_name,

Line 30276: INSERT INTO msc_local_id_misc

30272:
30273: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30274:
30275: -- Insert into the LID table with the user defined key
30276: INSERT INTO msc_local_id_misc
30277: (local_id,
30278: st_transaction_id,
30279: instance_id,
30280: entity_name,

Line 56723: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '

56719: -- update ABC_CLASS_ID where it exists in the planning system
56720: v_sql_stmt := 1;
56721: lv_sql_stmt :=
56722: ' UPDATE msc_st_system_items msi'
56723: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
56724: ||' WHERE mac.char1 = msi.sr_instance_code'
56725: ||' AND mac.char3 = msi.organization_code '
56726: ||' AND mac.char4 = msi.abc_class_name '
56727: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''

Line 56752: INSERT INTO msc_local_id_misc

56748: WHERE rowid = lb_rowid_abc(j);
56749:
56750:
56751: FORALL j IN lb_rowid_abc.FIRST..lb_rowid_abc.LAST
56752: INSERT INTO msc_local_id_misc
56753: (local_id,
56754: st_transaction_id,
56755: instance_id,
56756: entity_name,

Line 56792: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '

56788: -- update ABC_CLASS_ID for ABC_CLASS_NAME for which we have just populated the local id
56789: v_sql_stmt := 2;
56790: lv_sql_stmt :=
56791: ' UPDATE msc_st_system_items msi'
56792: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
56793: ||' WHERE mac.char1 = msi.sr_instance_code'
56794: ||' AND mac.char3 = msi.organization_code '
56795: ||' AND mac.char4 = msi.abc_class_name '
56796: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''