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 2773: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_MISC', v_instance_id, -1);

2769:
2770: END IF;
2771:
2772: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SETUP', v_instance_id, -1);
2773: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_MISC', v_instance_id, -1);
2774:
2775:
2776: EXCEPTION
2777: when others then

Line 16051: ||' FROM msc_local_id_misc'

16047: v_sql_stmt := 10;
16048: lv_sql_stmt :=
16049: ' UPDATE msc_st_category_sets'
16050: ||' SET sr_category_set_id = (SELECT local_id'
16051: ||' FROM msc_local_id_misc'
16052: ||' WHERE char1 = sr_instance_code'
16053: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||')='
16054: ||' NVL(company_name,'||''''||NULL_CHAR||''''||')'
16055: ||' AND char3 = category_set_name'

Line 16092: INSERT INTO msc_local_id_misc

16088: WHERE rowid = lb_rowid(j);
16089:
16090: v_sql_stmt := 12;
16091: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
16092: INSERT INTO msc_local_id_misc
16093: (local_id,
16094: st_transaction_id,
16095: instance_id,
16096: entity_name,

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

19344: -- update ABC_CLASS_ID where it exists in the planning system
19345: v_sql_stmt := 14;
19346: lv_sql_stmt :=
19347: ' UPDATE msc_st_system_items msi'
19348: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
19349: ||' WHERE mac.char1 = msi.sr_instance_code'
19350: ||' AND mac.char3 = msi.organization_code '
19351: ||' AND mac.char4 = msi.abc_class_name '
19352: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''

Line 19379: INSERT INTO msc_local_id_misc

19375: WHERE rowid = lb_rowid_abc(j);
19376:
19377:
19378: FORALL j IN lb_rowid_abc.FIRST..lb_rowid_abc.LAST
19379: INSERT INTO msc_local_id_misc
19380: (local_id,
19381: st_transaction_id,
19382: instance_id,
19383: entity_name,

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

19413: -- update ABC_CLASS_ID for ABC_CLASS_NAME for which we have just populated the local id
19414: v_sql_stmt := 15;
19415: lv_sql_stmt :=
19416: ' UPDATE msc_st_system_items msi'
19417: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
19418: ||' WHERE mac.char1 = msi.sr_instance_code'
19419: ||' AND mac.char3 = msi.organization_code '
19420: ||' AND mac.char4 = msi.abc_class_name '
19421: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''

Line 23883: ||' FROM msc_local_id_misc'

23879: v_sql_stmt := 07;
23880: lv_sql_stmt :=
23881: 'UPDATE msc_st_item_categories '
23882: ||' SET sr_category_set_id = (SELECT local_id'
23883: ||' FROM msc_local_id_misc'
23884: ||' WHERE char1 = sr_instance_code'
23885: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
23886: ||' NVL(company_name,'||''''||NULL_CHAR||''''||') '
23887: ||' AND char3 = category_set_name'

Line 23935: ||' FROM msc_local_id_misc'

23931: v_sql_stmt := 09;
23932: lv_sql_stmt :=
23933: 'UPDATE msc_st_item_categories '
23934: ||' SET sr_category_id = (SELECT local_id '
23935: ||' FROM msc_local_id_misc'
23936: ||' WHERE char1 = sr_instance_code'
23937: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
23938: ||' NVL(company_name,'||''''||NULL_CHAR||''''||') '
23939: ||' AND char3 = category_name'

Line 23977: INSERT INTO msc_local_id_misc

23973: WHERE rowid = lb_rowid(j);
23974:
23975: v_sql_stmt := 11;
23976: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
23977: INSERT INTO msc_local_id_misc
23978: (local_id,
23979: st_transaction_id,
23980: instance_id,
23981: entity_name,

Line 24022: ||' FROM msc_local_id_misc'

24018: v_sql_stmt := 09;
24019: lv_sql_stmt :=
24020: 'UPDATE msc_st_item_categories '
24021: ||' SET sr_category_id = (SELECT local_id '
24022: ||' FROM msc_local_id_misc'
24023: ||' WHERE char1 = sr_instance_code'
24024: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
24025: ||' NVL(company_name,'||''''||NULL_CHAR||''''||') '
24026: ||' AND char3 = category_name'

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

24860: v_sql_stmt :=14;
24861:
24862: lv_sql_stmt :=
24863: 'UPDATE MSC_ST_ITEM_SOURCING msis'
24864: ||' SET category_set_id = ( SELECT local_id FROM msc_local_id_misc mlim'
24865: ||' WHERE entity_name = ''SR_CATEGORY_SET_ID'' '
24866: ||' AND instance_id = '||v_instance_id
24867: ||' AND mlim.char1 = msis.sr_instance_code'
24868: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

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

24884: v_sql_stmt :=15;
24885:
24886: lv_sql_stmt :=
24887: 'UPDATE MSC_ST_ITEM_SOURCING msis'
24888: ||' SET category_id = ( SELECT local_id FROM msc_local_id_misc mlim'
24889: ||' WHERE entity_name = ''SR_CATEGORY_ID'' '
24890: ||' AND instance_id = '||v_instance_id
24891: ||' AND mlim.char1 = msis.sr_instance_code'
24892: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 25152: ||' FROM msc_local_id_misc mlim'

25148:
25149: lv_sql_stmt:=
25150: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25151: ||' SET sourcing_rule_id = (SELECT local_id '
25152: ||' FROM msc_local_id_misc mlim'
25153: ||' WHERE mlim.entity_name= ''SOURCING_RULE_ID'' '
25154: ||' AND mlim.char1 = msis.sr_instance_code'
25155: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25156: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25174: ||' FROM msc_local_id_misc mlim'

25170: v_sql_stmt := 19;
25171: lv_sql_stmt:=
25172: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25173: ||' SET assignment_set_id = (SELECT local_id'
25174: ||' FROM msc_local_id_misc mlim'
25175: ||' WHERE mlim.entity_name= ''ASSIGNMENT_SET_ID'' '
25176: ||' AND mlim.char1 = msis.sr_instance_code'
25177: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25178: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25196: ||' FROM msc_local_id_misc mlim'

25192:
25193: lv_sql_stmt:=
25194: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25195: ||' SET sr_receipt_id = (SELECT local_id'
25196: ||' FROM msc_local_id_misc mlim'
25197: ||' WHERE mlim.entity_name= ''SR_RECEIPT_ID'' '
25198: ||' AND mlim.char1 = msis.sr_instance_code'
25199: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25200: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25226: ||' FROM msc_local_id_misc mlim'

25222:
25223: lv_sql_stmt:=
25224: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25225: ||' SET sr_source_id = (SELECT local_id'
25226: ||' FROM msc_local_id_misc mlim'
25227: ||' WHERE mlim.entity_name= ''SR_SOURCE_ID'' '
25228: ||' AND mlim.char1 = msis.sr_instance_code'
25229: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25230: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25263: ||' FROM msc_local_id_misc mlim'

25259:
25260: lv_sql_stmt:=
25261: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25262: ||' SET assignment_id = (SELECT local_id '
25263: ||' FROM msc_local_id_misc mlim'
25264: ||' WHERE mlim.entity_name= ''ASSIGNMENT_ID'' '
25265: ||' AND mlim.instance_id = '||v_instance_id
25266: ||' AND mlim.char1 = msis.sr_instance_code'
25267: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 25350: INSERT INTO msc_local_id_misc

25346: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25347:
25348: -- Insert into the LID table
25349:
25350: INSERT INTO msc_local_id_misc
25351: (local_id,
25352: st_transaction_id,
25353: instance_id,
25354: entity_name,

Line 25404: ||' FROM msc_local_id_misc mlim'

25400:
25401: lv_sql_stmt:=
25402: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25403: ||' SET sourcing_rule_id = (SELECT local_id '
25404: ||' FROM msc_local_id_misc mlim'
25405: ||' WHERE mlim.entity_name= ''SOURCING_RULE_ID'' '
25406: ||' AND mlim.char1 = msis.sr_instance_code'
25407: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25408: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25444: INSERT INTO msc_local_id_misc

25440: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25441:
25442: -- Insert into the LID table
25443:
25444: INSERT INTO msc_local_id_misc
25445: (local_id,
25446: st_transaction_id,
25447: instance_id,
25448: entity_name,

Line 25483: ||' FROM msc_local_id_misc mlim'

25479: v_sql_stmt := 29;
25480: lv_sql_stmt:=
25481: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25482: ||' SET assignment_set_id = (SELECT local_id'
25483: ||' FROM msc_local_id_misc mlim'
25484: ||' WHERE mlim.entity_name= ''ASSIGNMENT_SET_ID'' '
25485: ||' AND mlim.char1 = msis.sr_instance_code'
25486: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25487: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25519: INSERT INTO msc_local_id_misc

25515: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25516:
25517: -- Insert into the LID table
25518:
25519: INSERT INTO msc_local_id_misc
25520: (local_id,
25521: st_transaction_id,
25522: instance_id,
25523: entity_name,

Line 25584: ||' FROM msc_local_id_misc mlim'

25580:
25581: lv_sql_stmt:=
25582: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25583: ||' SET sr_receipt_id = (SELECT local_id'
25584: ||' FROM msc_local_id_misc mlim'
25585: ||' WHERE mlim.entity_name= ''SR_RECEIPT_ID'' '
25586: ||' AND mlim.char1 = msis.sr_instance_code'
25587: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25588: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25629: INSERT INTO msc_local_id_misc

25625: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25626:
25627: -- Insert into the LID table
25628:
25629: INSERT INTO msc_local_id_misc
25630: (local_id,
25631: st_transaction_id,
25632: instance_id,
25633: entity_name,

Line 25709: ||' FROM msc_local_id_misc mlim'

25705:
25706: lv_sql_stmt:=
25707: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25708: ||' SET sr_source_id = (SELECT local_id'
25709: ||' FROM msc_local_id_misc mlim'
25710: ||' WHERE mlim.entity_name= ''SR_SOURCE_ID'' '
25711: ||' AND mlim.char1 = msis.sr_instance_code'
25712: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
25713: ||' = NVL(msis.company_name,'||''''||NULL_CHAR||''''||') '

Line 25762: INSERT INTO msc_local_id_misc

25758:
25759: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25760: -- Insert into the LID table
25761:
25762: INSERT INTO msc_local_id_misc
25763: (local_id,
25764: st_transaction_id,
25765: instance_id,
25766: entity_name,

Line 25820: ||' FROM msc_local_id_misc mlim'

25816:
25817: lv_sql_stmt:=
25818: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25819: ||' SET assignment_id = (SELECT local_id '
25820: ||' FROM msc_local_id_misc mlim'
25821: ||' WHERE mlim.entity_name= ''ASSIGNMENT_ID'' '
25822: ||' AND mlim.instance_id = '||v_instance_id
25823: ||' AND mlim.char1 = msis.sr_instance_code'
25824: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 26548: ||' FROM msc_local_id_misc mlim'

26544:
26545: lv_sql_stmt :=
26546: 'UPDATE msc_st_project_tasks mstp'
26547: ||' SET costing_group_id = ( SELECT local_id '
26548: ||' FROM msc_local_id_misc mlim'
26549: ||' WHERE mlim.char1 = mstp.sr_instance_code'
26550: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
26551: ||' = NVL(mstp.company_name,'||''''||NULL_CHAR||''''||') '
26552: /* ||' AND mlim.char3 = mstp.organization_code'*/

Line 26601: INSERT INTO msc_local_id_misc

26597:
26598: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26599: -- Insert into the LID table with the user defined key
26600:
26601: INSERT INTO msc_local_id_misc
26602: (local_id,
26603: st_transaction_id,
26604: instance_id,
26605: entity_name,

Line 26645: ||' FROM msc_local_id_misc mlim'

26641:
26642: lv_sql_stmt :=
26643: 'UPDATE msc_st_project_tasks mstp'
26644: ||' SET costing_group_id = ( SELECT local_id '
26645: ||' FROM msc_local_id_misc mlim'
26646: ||' WHERE mlim.char1 = mstp.sr_instance_code'
26647: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '
26648: ||' = NVL(mstp.company_name,'||''''||NULL_CHAR||''''||') '
26649: /* ||' AND mlim.char3 = mstp.organization_code'*/

Line 26686: INSERT INTO msc_local_id_misc

26682:
26683: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26684:
26685: -- Insert into the LID table with the user defined key
26686: INSERT INTO msc_local_id_misc
26687: (local_id,
26688: st_transaction_id,
26689: instance_id,
26690: entity_name,

Line 26762: INSERT INTO msc_local_id_misc

26758:
26759: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26760:
26761: -- Insert into the LID table with the user defined key
26762: INSERT INTO msc_local_id_misc
26763: (local_id,
26764: st_transaction_id,
26765: instance_id,
26766: entity_name,

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

51704: -- update ABC_CLASS_ID where it exists in the planning system
51705: v_sql_stmt := 1;
51706: lv_sql_stmt :=
51707: ' UPDATE msc_st_system_items msi'
51708: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
51709: ||' WHERE mac.char1 = msi.sr_instance_code'
51710: ||' AND mac.char3 = msi.organization_code '
51711: ||' AND mac.char4 = msi.abc_class_name '
51712: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''

Line 51737: INSERT INTO msc_local_id_misc

51733: WHERE rowid = lb_rowid_abc(j);
51734:
51735:
51736: FORALL j IN lb_rowid_abc.FIRST..lb_rowid_abc.LAST
51737: INSERT INTO msc_local_id_misc
51738: (local_id,
51739: st_transaction_id,
51740: instance_id,
51741: entity_name,

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

51773: -- update ABC_CLASS_ID for ABC_CLASS_NAME for which we have just populated the local id
51774: v_sql_stmt := 2;
51775: lv_sql_stmt :=
51776: ' UPDATE msc_st_system_items msi'
51777: ||' SET abc_class_id = (SELECT local_id from MSC_LOCAL_ID_MISC mac '
51778: ||' WHERE mac.char1 = msi.sr_instance_code'
51779: ||' AND mac.char3 = msi.organization_code '
51780: ||' AND mac.char4 = msi.abc_class_name '
51781: ||' AND mac.ENTITY_NAME = ''ABC_CLASS_ID'''