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_SETUP

Line 2772: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SETUP', v_instance_id, -1);

2768: END;
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

Line 3214: FROM msc_local_id_setup

3210: v_sql_stmt := 1;
3211: UPDATE msc_st_trading_partners
3212: SET modeled_customer_id =
3213: (SELECT local_id
3214: FROM msc_local_id_setup
3215: WHERE char1 = sr_instance_code
3216: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
3217: AND char3 = modeled_customer_name
3218: AND number1 = G_CUSTOMER

Line 3229: FROM msc_local_id_setup

3225: v_sql_stmt := 2;
3226: UPDATE msc_st_trading_partners
3227: SET modeled_supplier_id =
3228: (SELECT local_id
3229: FROM msc_local_id_setup
3230: WHERE char1 = sr_instance_code
3231: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
3232: AND char3 = modeled_supplier_name
3233: AND number1 = G_VENDOR

Line 3244: FROM msc_local_id_setup

3240: v_sql_stmt := 3;
3241: UPDATE msc_st_trading_partners
3242: SET modeled_customer_site_id =
3243: (SELECT local_id
3244: FROM msc_local_id_setup
3245: WHERE char1 = sr_instance_code
3246: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
3247: AND char3 = modeled_customer_name
3248: AND char4 = modeled_customer_site_code

Line 3260: FROM msc_local_id_setup

3256: v_sql_stmt := 4;
3257: UPDATE msc_st_trading_partners
3258: SET modeled_supplier_site_id =
3259: (SELECT local_id
3260: FROM msc_local_id_setup
3261: WHERE char1 = sr_instance_code
3262: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
3263: AND char3 = modeled_supplier_name
3264: AND char4 = modeled_supplier_site_code

Line 3306: FROM msc_local_id_setup

3302:
3303: UPDATE msc_st_trading_partners
3304: SET master_organization =
3305: (SELECT local_id
3306: FROM msc_local_id_setup
3307: WHERE char1 = sr_instance_code
3308: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
3309: AND char3 = master_organization_code
3310: AND number1 = G_ORGANIZATION

Line 3648: 'INSERT INTO msc_local_id_setup'

3644:
3645: IF p_shift_exist = SYS_NO THEN
3646: v_sql_stmt := 2;
3647: lv_sql_stmt :=
3648: 'INSERT INTO msc_local_id_setup'
3649: ||' (local_id, '
3650: ||' st_transaction_id,'
3651: ||' instance_id,'
3652: ||' entity_name,'

Line 4420: ||' FROM msc_local_id_setup'

4416: BEGIN
4417: v_sql_stmt := 12;
4418: lv_sql_stmt :=
4419: 'SELECT local_id '
4420: ||' FROM msc_local_id_setup'
4421: ||' WHERE char1 = :v_instance_code'
4422: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '
4423: ||' NVL(:company_name,'||''''||NULL_CHAR||''''||') '
4424: ||' AND char3 = :calendar_code'

Line 6901: SELECT mlis.char3 from msc_local_id_setup mlis

6897: WHERE mstp.organization_code = mtp.organization_code
6898: AND mtp.sr_instance_id = v_instance_id
6899: AND mtp.partner_type = G_ORGANIZATION
6900: MINUS
6901: SELECT mlis.char3 from msc_local_id_setup mlis
6902: WHERE mlis.entity_name = 'SR_TP_ID'
6903: AND mlis.char1 = mstp.sr_instance_code
6904: AND mlis.number1 = mstp.partner_type
6905: AND nvl(mlis.char2, NULL_CHAR) = nvl(mstp.company_name,NULL_CHAR));

Line 7231: SET company_id = (SELECT local_id from MSC_LOCAL_ID_SETUP

7227:
7228: -- if not 'My Company' then get the first occurence of sr_tp_id for this company_name
7229:
7230: UPDATE msc_st_trading_partners mscu
7231: SET company_id = (SELECT local_id from MSC_LOCAL_ID_SETUP
7232: WHERE char1 = mscu.sr_instance_code
7233: and NVL(char3,NULL_CHAR) = NVL(mscu.company_name,NULL_CHAR)
7234: and entity_name = 'SR_TP_ID'
7235: and rownum = 1) -- we need the first occurence of sr_tp_id

Line 7493: INSERT INTO msc_local_id_setup

7489: -- user defined key
7490:
7491: v_sql_stmt := 18;
7492: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7493: INSERT INTO msc_local_id_setup
7494: (local_id,
7495: st_transaction_id,
7496: instance_id,
7497: entity_name,

Line 8149: ||' FROM msc_local_id_setup mls'

8145: v_sql_stmt := 28;
8146: lv_sql_stmt :=
8147: 'UPDATE msc_st_trading_partner_sites mts'
8148: ||' SET sr_tp_site_id = (SELECT local_id'
8149: ||' FROM msc_local_id_setup mls'
8150: ||' WHERE mls.char1 = mts.sr_instance_code'
8151: ||' AND mls.char3 = mts.location'
8152: ||' AND mls.entity_name = ''LOCATION_ID'' )'
8153: ||' WHERE process_flag = '||G_IN_PROCESS

Line 8175: 'UPDATE msc_local_id_setup mls'

8171:
8172: v_sql_stmt := 29;
8173: v_sql_stmt := 29;
8174: lv_sql_stmt :=
8175: 'UPDATE msc_local_id_setup mls'
8176: ||' SET mls.char4 = NVL( (select mts.location '
8177: ||' FROM msc_st_trading_partner_sites mts'
8178: ||' WHERE mls.char1 = mts.sr_instance_code'
8179: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 8226: INSERT INTO msc_local_id_setup

8222:
8223: -- Insert record in LID
8224: v_sql_stmt := 30;
8225: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8226: INSERT INTO msc_local_id_setup
8227: (local_id,
8228: st_transaction_id,
8229: instance_id,
8230: entity_name,

Line 8279: INSERT INTO msc_local_id_setup

8275:
8276: -- Insert record in LID
8277: v_sql_stmt := 32;
8278: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8279: INSERT INTO msc_local_id_setup
8280: (local_id,
8281: st_transaction_id,
8282: instance_id,
8283: entity_name,

Line 8317: ||' FROM msc_local_id_setup mls'

8313: v_sql_stmt := 32.1;
8314: lv_sql_stmt :=
8315: 'UPDATE msc_st_trading_partner_sites mts'
8316: ||' SET sr_tp_site_id = (SELECT local_id'
8317: ||' FROM msc_local_id_setup mls'
8318: ||' WHERE mls.char1 = mts.sr_instance_code'
8319: ||' AND mls.char3 = mts.location'
8320: ||' AND mls.entity_name = ''LOCATION_ID'' )'
8321: ||' WHERE process_flag = '||G_IN_PROCESS

Line 9175: ||' FROM msc_local_id_setup mls'

9171: v_sql_stmt := 42;
9172: lv_sql_stmt :=
9173: 'UPDATE msc_st_location_associations mla'
9174: ||' SET location_id = (SELECT local_id'
9175: ||' FROM msc_local_id_setup mls'
9176: ||' WHERE mls.char1 = mla.sr_instance_code'
9177: ||' AND mls.char3 = mla.location_code'
9178: ||' AND mls.entity_name = ''LOCATION_ID'' )'
9179: ||' WHERE process_flag = '||G_IN_PROCESS

Line 9256: INSERT INTO msc_local_id_setup

9252:
9253: -- Insert record in LID
9254: v_sql_stmt := 43.2;
9255: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9256: INSERT INTO msc_local_id_setup
9257: (local_id,
9258: st_transaction_id,
9259: instance_id,
9260: entity_name,

Line 9294: ||' FROM msc_local_id_setup mls'

9290: v_sql_stmt := 43.3;
9291: lv_sql_stmt :=
9292: 'UPDATE msc_st_location_associations mla'
9293: ||' SET location_id = (SELECT local_id'
9294: ||' FROM msc_local_id_setup mls'
9295: ||' WHERE mls.char1 = mla.sr_instance_code'
9296: ||' AND mls.char3 = mla.location_code'
9297: ||' AND mls.entity_name = ''LOCATION_ID'' )'
9298: ||' WHERE process_flag = '||G_IN_PROCESS

Line 10226: INSERT INTO msc_local_id_setup

10222: WHERE rowid = lb_rowid(j);
10223:
10224: v_sql_stmt := 65;
10225: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10226: INSERT INTO msc_local_id_setup
10227: (local_id,
10228: st_transaction_id,
10229: instance_id,
10230: entity_name,

Line 12970: ||' FROM msc_local_id_setup mls'

12966: v_sql_stmt := 08;
12967: lv_sql_stmt :=
12968: 'UPDATE msc_st_interorg_ship_methods msis'
12969: ||' SET from_location_id = (SELECT local_id'
12970: ||' FROM msc_local_id_setup mls'
12971: ||' WHERE mls.char1 = msis.sr_instance_code'
12972: ||' AND mls.char3 = msis.from_location_code'
12973: ||' AND mls.entity_name = ''LOCATION_ID'' )'
12974: ||' WHERE process_flag = '||G_IN_PROCESS

Line 12992: ||' FROM msc_local_id_setup mls'

12988: v_sql_stmt := 09;
12989: lv_sql_stmt :=
12990: 'UPDATE msc_st_interorg_ship_methods msis'
12991: ||' SET to_location_id = (SELECT local_id'
12992: ||' FROM msc_local_id_setup mls'
12993: ||' WHERE mls.char1 = msis.sr_instance_code'
12994: ||' AND mls.char3 = msis.to_location_code'
12995: ||' AND mls.entity_name = ''LOCATION_ID'' )'
12996: ||' WHERE process_flag = '||G_IN_PROCESS

Line 13117: ||' FROM msc_local_id_setup mls'

13113:
13114: lv_sql_stmt :=
13115: 'UPDATE msc_st_interorg_ship_methods msr'
13116: ||' SET from_region_id = (SELECT local_id'
13117: ||' FROM msc_local_id_setup mls'
13118: ||' WHERE mls.char1 = msr.sr_instance_code'
13119: ||' AND mls.number1 = nvl(msr.from_region_type,'||NULL_VALUE||')'
13120: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
13121: ||' NVL(msr.from_country, '||''''||NULL_CHAR||''''||') '

Line 13156: ||' FROM msc_local_id_setup mls'

13152:
13153: lv_sql_stmt :=
13154: 'UPDATE msc_st_interorg_ship_methods msr'
13155: ||' SET to_region_id = (SELECT local_id'
13156: ||' FROM msc_local_id_setup mls'
13157: ||' WHERE mls.char1 = msr.sr_instance_code'
13158: ||' AND mls.number1 = nvl(msr.to_region_type,'||NULL_VALUE||')'
13159: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
13160: ||' NVL(msr.to_country, '||''''||NULL_CHAR||''''||') '

Line 13923: ||' FROM msc_local_id_setup mls'

13919:
13920: lv_sql_stmt :=
13921: 'UPDATE msc_st_regions msr'
13922: ||' SET region_id = (SELECT local_id'
13923: ||' FROM msc_local_id_setup mls'
13924: ||' WHERE mls.char1 = msr.sr_instance_code'
13925: ||' AND mls.number1 = msr.region_type'
13926: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
13927: ||' NVL(msr.country, '||''''||NULL_CHAR||''''||') '

Line 14017: INSERT INTO msc_local_id_setup

14013: WHERE rowid = lb_rowid(j);
14014:
14015: v_sql_stmt := 13;
14016: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
14017: INSERT INTO msc_local_id_setup
14018: (local_id,
14019: st_transaction_id,
14020: instance_id,
14021: entity_name,

Line 14465: ||' FROM msc_local_id_setup mls'

14461:
14462: lv_sql_stmt :=
14463: 'UPDATE msc_st_zone_regions mszr'
14464: ||' SET region_id = (SELECT local_id'
14465: ||' FROM msc_local_id_setup mls'
14466: ||' WHERE mls.char1 = mszr.sr_instance_code'
14467: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
14468: ||' NVL(mszr.country, '||''''||NULL_CHAR||''''||') '
14469: ||' AND NVL(mls.char3, '||''''||NULL_CHAR||''''||') = '

Line 14530: ||' FROM msc_local_id_setup mls'

14526:
14527: lv_sql_stmt :=
14528: 'UPDATE msc_st_zone_regions mszr'
14529: ||' SET parent_region_id = (SELECT local_id'
14530: ||' FROM msc_local_id_setup mls'
14531: ||' WHERE mls.char1 = mszr.sr_instance_code'
14532: ||' AND NVL(mls.char10, '||''''||NULL_CHAR||''''||') = '
14533: ||' NVL(mszr.zone, '||''''||NULL_CHAR||''''||') '
14534: ||' AND mls.number1 = 10 '

Line 14601: ||' FROM msc_local_id_setup mls'

14597:
14598: lv_sql_stmt :=
14599: 'UPDATE msc_st_zone_regions mszr'
14600: ||' SET zone_region_id = (SELECT local_id'
14601: ||' FROM msc_local_id_setup mls'
14602: ||' WHERE mls.char1 = mszr.sr_instance_code'
14603: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
14604: ||' NVL(mszr.country, '||''''||NULL_CHAR||''''||') '
14605: ||' AND NVL(mls.char3, '||''''||NULL_CHAR||''''||') = '

Line 14660: INSERT INTO msc_local_id_setup

14656: WHERE rowid = lb_rowid(j);
14657:
14658: v_sql_stmt := 13;
14659: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
14660: INSERT INTO msc_local_id_setup
14661: (local_id,
14662: st_transaction_id,
14663: instance_id,
14664: entity_name,

Line 15045: ||' FROM msc_local_id_setup mls'

15041:
15042: lv_sql_stmt :=
15043: 'UPDATE msc_st_region_locations msr'
15044: ||' SET region_id = (SELECT local_id'
15045: ||' FROM msc_local_id_setup mls'
15046: ||' WHERE mls.char1 = msr.sr_instance_code'
15047: ||' AND NVL(mls.number1, '||NULL_VALUE||') = NVL(msr.region_type,'||NULL_VALUE||')'
15048: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
15049: ||' NVL(msr.country, '||''''||NULL_CHAR||''''||') '

Line 15082: ||' FROM msc_local_id_setup mls'

15078: --Deriving location_id
15079: lv_sql_stmt :=
15080: 'UPDATE msc_st_region_locations msr'
15081: ||' SET location_id = (SELECT local_id'
15082: ||' FROM msc_local_id_setup mls'
15083: ||' WHERE mls.char1 = msr.sr_instance_code'
15084: ||' AND mls.char3 = msr.location_code'
15085: ||' AND mls.entity_name = ''LOCATION_ID'' )'
15086: ||' WHERE process_flag = '||G_IN_PROCESS

Line 15154: INSERT INTO msc_local_id_setup

15150: WHERE rowid = lb_rowid(j);
15151:
15152: -- Insert record in LID
15153: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
15154: INSERT INTO msc_local_id_setup
15155: (local_id,
15156: st_transaction_id,
15157: instance_id,
15158: entity_name,

Line 15188: ||' FROM msc_local_id_setup mls'

15184:
15185: lv_sql_stmt :=
15186: 'UPDATE msc_st_region_locations msr'
15187: ||' SET location_id = (SELECT local_id'
15188: ||' FROM msc_local_id_setup mls'
15189: ||' WHERE mls.char1 = msr.sr_instance_code'
15190: ||' AND mls.char3 = msr.location_code'
15191: ||' AND mls.entity_name = ''LOCATION_ID'' )'
15192: ||' WHERE process_flag = '||G_IN_PROCESS

Line 15516: ||' FROM msc_local_id_setup mls'

15512:
15513: lv_sql_stmt :=
15514: 'UPDATE msc_st_region_sites msr'
15515: ||' SET region_id = (SELECT local_id'
15516: ||' FROM msc_local_id_setup mls'
15517: ||' WHERE mls.char1 = msr.sr_instance_code'
15518: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
15519: ||' NVL(msr.country, '||''''||NULL_CHAR||''''||') '
15520: ||' AND NVL(mls.char3, '||''''||NULL_CHAR||''''||') = '

Line 28025: ||' FROM msc_local_id_setup mlis'

28021:
28022: lv_sql_stmt :=
28023: 'UPDATE msc_st_department_resources msdr'
28024: ||' SET department_id= (SELECT local_id'
28025: ||' FROM msc_local_id_setup mlis'
28026: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28027: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28028: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
28029: ||' AND mlis.char3 = msdr.organization_code'

Line 28049: ||' FROM msc_local_id_setup mlis'

28045:
28046: lv_sql_stmt :=
28047: 'UPDATE msc_st_department_resources msdr'
28048: ||' SET department_id= (SELECT local_id '
28049: ||' FROM msc_local_id_setup mlis'
28050: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28051: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28052: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
28053: ||' AND mlis.char3 = msdr.organization_code'

Line 28074: ||' FROM msc_local_id_setup mlis'

28070:
28071: lv_sql_stmt :=
28072: 'UPDATE msc_st_department_resources msdr'
28073: ||' SET resource_id= (SELECT local_id'
28074: ||' FROM msc_local_id_setup mlis'
28075: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28076: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28077: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
28078: ||' AND mlis.char3 = msdr.organization_code'

Line 28143: INSERT INTO msc_local_id_setup

28139: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28140:
28141: -- Insert into the LID table this new department with the user defined key
28142:
28143: INSERT INTO msc_local_id_setup
28144: (local_id,
28145: st_transaction_id,
28146: instance_id,
28147: entity_name,

Line 28187: ||' FROM msc_local_id_setup mlis'

28183:
28184: lv_sql_stmt :=
28185: 'UPDATE msc_st_department_resources msdr'
28186: ||' SET department_id= (SELECT local_id'
28187: ||' FROM msc_local_id_setup mlis'
28188: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28189: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28190: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
28191: ||' AND mlis.char3 = msdr.organization_code'

Line 28228: ||' FROM msc_local_id_setup mlis'

28224:
28225: lv_sql_stmt :=
28226: 'UPDATE msc_st_department_resources msdr'
28227: ||' SET owning_department_id= (SELECT local_id'
28228: ||' FROM msc_local_id_setup mlis'
28229: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28230: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28231: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
28232: ||' AND mlis.char3 = msdr.organization_code'

Line 28307: INSERT INTO msc_local_id_setup

28303: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28304:
28305: -- Insert into the LID table this new resource with the user defined key
28306:
28307: INSERT INTO msc_local_id_setup
28308: (local_id,
28309: st_transaction_id,
28310: instance_id,
28311: entity_name,

Line 28354: ||' FROM msc_local_id_setup mlis'

28350:
28351: lv_sql_stmt :=
28352: 'UPDATE msc_st_department_resources msdr'
28353: ||' SET resource_id= (SELECT local_id'
28354: ||' FROM msc_local_id_setup mlis'
28355: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28356: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28357: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
28358: ||' AND mlis.char3 = msdr.organization_code'

Line 28392: INSERT INTO msc_local_id_setup

28388: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28389:
28390: -- Insert into the LID table this new department with the user defined key
28391:
28392: INSERT INTO msc_local_id_setup
28393: (local_id,
28394: st_transaction_id,
28395: instance_id,
28396: entity_name,

Line 28693: ||' FROM msc_local_id_setup mlis'

28689: v_sql_stmt := 25;
28690: lv_sql_stmt :=
28691: 'UPDATE msc_st_resource_shifts msrs'
28692: ||' SET department_id = (SELECT local_id'
28693: ||' FROM msc_local_id_setup mlis'
28694: ||' WHERE mlis.char1 = msrs.sr_instance_code'
28695: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28696: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '
28697: ||' AND mlis.char3 = msrs.organization_code'

Line 28750: ||' SET resource_id = (SELECT local_id FROM msc_local_id_setup mlis'

28746: -- Popluate the resource id from LOCAL_ID table
28747: v_sql_stmt := 27;
28748: lv_sql_stmt:=
28749: 'UPDATE msc_st_resource_shifts msrs'
28750: ||' SET resource_id = (SELECT local_id FROM msc_local_id_setup mlis'
28751: ||' WHERE mlis.char1 = msrs.sr_instance_code'
28752: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28753: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '
28754: ||' AND mlis.char3 = msrs.organization_code'

Line 28810: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '

28806: v_sql_stmt := 29;
28807: lv_sql_stmt :=
28808: 'UPDATE msc_st_resource_shifts msrs'
28809: ||' SET shift_num =(SELECT mlis.local_id'
28810: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '
28811: ||' WHERE mtp.sr_instance_id = '||v_instance_id
28812: ||' AND mlis.char1 = msrs.sr_instance_code'
28813: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28814: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '

Line 28836: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '

28832:
28833: lv_sql_stmt :=
28834: 'UPDATE msc_st_resource_shifts msrs'
28835: ||' SET shift_num =(SELECT mlis.local_id'
28836: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
28837: ||' WHERE mtp.sr_instance_id = '||v_instance_id
28838: ||' AND mlis.char1 = msrs.sr_instance_code'
28839: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28840: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '

Line 29266: ||' FROM msc_local_id_setup mlis'

29262: v_sql_stmt := 39;
29263: lv_sql_stmt :=
29264: 'UPDATE msc_st_resource_changes msrc'
29265: ||' SET department_id = (SELECT local_id'
29266: ||' FROM msc_local_id_setup mlis'
29267: ||' WHERE mlis.char1 = msrc.sr_instance_code'
29268: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
29269: ||' = NVL(msrc.company_name,'||''''||NULL_CHAR||''''||') '
29270: ||' AND mlis.char3 = msrc.organization_code'

Line 29324: ||' FROM msc_local_id_setup mlis'

29320: v_sql_stmt := 41;
29321: lv_sql_stmt:=
29322: 'UPDATE msc_st_resource_changes msrc'
29323: ||' SET resource_id = (SELECT local_id'
29324: ||' FROM msc_local_id_setup mlis'
29325: ||' WHERE mlis.char1 = msrc.sr_instance_code'
29326: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
29327: ||' = NVL(msrc.company_name,'||''''||NULL_CHAR||''''||') '
29328: ||' AND mlis.char3 = msrc.organization_code'

Line 29385: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '

29381:
29382: lv_sql_stmt :=
29383: 'UPDATE msc_st_resource_changes msrc'
29384: ||' SET shift_num =(SELECT mlis.local_id'
29385: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '
29386: ||' WHERE mtp.sr_instance_id = '||v_instance_id
29387: ||' AND mlis.char1 = msrc.sr_instance_code'
29388: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
29389: ||' = NVL(msrc.company_name,'||''''||NULL_CHAR||''''||') '

Line 29411: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '

29407:
29408: lv_sql_stmt :=
29409: 'UPDATE msc_st_resource_changes msrc'
29410: ||' SET shift_num =(SELECT mlis.local_id'
29411: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
29412: ||' WHERE mtp.sr_instance_id = '||v_instance_id
29413: ||' AND mlis.char1 = msrc.sr_instance_code'
29414: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
29415: ||' = NVL(msrc.company_name,'||''''||NULL_CHAR||''''||') '

Line 30016: FROM msc_local_id_setup

30012: END IF;
30013:
30014: UPDATE MSC_ST_SUPPLIES
30015: SET PLANNING_PARTNER_SITE_ID = (SELECT local_id
30016: FROM msc_local_id_setup
30017: WHERE char1 = sr_instance_code
30018: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
30019: AND char4 = PLANNING_PARTNER_SITE_CODE
30020: AND number1 = G_VENDOR

Line 30033: FROM msc_local_id_setup

30029:
30030:
30031: UPDATE MSC_ST_SUPPLIES
30032: SET PLANNING_PARTNER_SITE_ID = (SELECT local_id
30033: FROM msc_local_id_setup
30034: WHERE char1 = sr_instance_code
30035: AND char3 = PLANNING_PARTNER_SITE_CODE
30036: AND number1 = G_ORGANIZATION
30037: AND entity_name = 'SR_TP_ID' )

Line 30061: FROM msc_local_id_setup

30057: AND ORDER_TYPE=18;
30058:
30059: UPDATE MSC_ST_SUPPLIES
30060: SET OWNING_PARTNER_SITE_ID = (SELECT local_id
30061: FROM msc_local_id_setup
30062: WHERE char1 = sr_instance_code
30063: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)
30064: AND char4 = OWNING_PARTNER_SITE_CODE
30065: AND number1 = G_VENDOR

Line 30076: FROM msc_local_id_setup

30072: AND ORDER_TYPE=18;
30073:
30074: UPDATE MSC_ST_SUPPLIES
30075: SET OWNING_PARTNER_SITE_ID = (SELECT local_id
30076: FROM msc_local_id_setup
30077: WHERE char1 = sr_instance_code
30078: AND char3 = OWNING_PARTNER_SITE_CODE
30079: AND number1 = G_ORGANIZATION
30080: AND entity_name = 'SR_TP_ID')

Line 35118: SET SR_COMPANY_ID = (SELECT local_id from MSC_LOCAL_ID_SETUP

35114: /* Calling derive_company_id
35115: v_sql_stmt := 04;
35116:
35117: UPDATE MSC_ST_COMPANY_USERS mscu
35118: SET SR_COMPANY_ID = (SELECT local_id from MSC_LOCAL_ID_SETUP
35119: WHERE char1 = mscu.sr_instance_code
35120: and NVL(char3,NULL_CHAR) = NVL(mscu.company_name,NULL_CHAR)
35121: and entity_name = 'SR_TP_ID'
35122: and rownum = 1) -- we need the first occurence of sr_tp_id

Line 35176: SET PARTNER_TYPE = (SELECT number1 from MSC_LOCAL_ID_SETUP

35172:
35173: v_sql_stmt := 05;
35174:
35175: UPDATE MSC_ST_COMPANY_USERS mscu
35176: SET PARTNER_TYPE = (SELECT number1 from MSC_LOCAL_ID_SETUP
35177: WHERE char1 = mscu.sr_instance_code
35178: and NVL(char3,NULL_CHAR) = NVL(mscu.company_name,NULL_CHAR)
35179: and entity_name = 'SR_TP_ID'
35180: and number1 in (1,2)

Line 35505: ||' FROM msc_local_id_setup mlis'

35501: -- Derive the component_sequence_id --
35502: lv_sql_stmt :=
35503: 'UPDATE msc_st_bom_components mbc'
35504: ||' SET component_sequence_id= (SELECT local_id '
35505: ||' FROM msc_local_id_setup mlis'
35506: ||' WHERE mlis.char1 = mbc.sr_instance_code'
35507: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
35508: ||' = NVL(mbc.company_name,'||''''||NULL_CHAR||''''||') '
35509: ||' AND mlis.char3 = mbc.organization_code'

Line 35544: INSERT INTO msc_local_id_setup

35540: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35541:
35542: -- Insert into the LID table
35543:
35544: INSERT INTO msc_local_id_setup
35545: (local_id,
35546: st_transaction_id,
35547: instance_id,
35548: entity_name,

Line 35678: FROM msc_st_bom_components mbc, msc_local_id_setup mlis

35674: AND batch_id = p_batch_id;
35675:
35676: CURSOR c7(p_batch_id NUMBER) IS
35677: SELECT mlis.rowid
35678: FROM msc_st_bom_components mbc, msc_local_id_setup mlis
35679: WHERE mlis.char1 = mbc.sr_instance_code
35680: AND NVL(mlis.char2,'-23453') = NVL(mbc.company_name,'-23453')
35681: AND mlis.char3 = mbc.organization_code
35682: AND mlis.char4 = mbc.bom_name

Line 36223: INSERT INTO msc_local_id_setup

36219: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36220:
36221: -- Insert into the LID table this new BOM with the user defined key
36222:
36223: INSERT INTO msc_local_id_setup
36224: (local_id,
36225: st_transaction_id,
36226: instance_id,
36227: entity_name,

Line 36597: ||' FROM msc_local_id_setup mlis'

36593:
36594: lv_sql_stmt:=
36595: 'UPDATE msc_st_bom_components mbc'
36596: ||' SET assembly_name = (SELECT char5'
36597: ||' FROM msc_local_id_setup mlis'
36598: ||' WHERE mlis.char1 = mbc.sr_instance_code'
36599: ||' AND mlis.char3 = mbc.organization_code'
36600: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
36601: ||' = NVL(mbc.company_name,'||''''||NULL_CHAR||''''||') '

Line 36778: ||' FROM msc_local_id_setup mlis'

36774: v_sql_stmt := 20;
36775: lv_sql_stmt :=
36776: 'UPDATE msc_st_bom_components mbc'
36777: ||' SET component_sequence_id= (SELECT local_id '
36778: ||' FROM msc_local_id_setup mlis'
36779: ||' WHERE mlis.char1 = mbc.sr_instance_code'
36780: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
36781: ||' = NVL(mbc.company_name,'||''''||NULL_CHAR||''''||') '
36782: ||' AND mlis.char3 = mbc.organization_code'

Line 36854: ||' msc_local_id_setup mlis'

36850: 'UPDATE msc_st_bom_components mbc'
36851: ||' SET process_flag = '||G_ERROR_FLG||','
36852: ||' error_text = '||''''||lv_message_text||''''
36853: ||' WHERE EXISTS (SELECT 1 FROM'
36854: ||' msc_local_id_setup mlis'
36855: ||' WHERE mlis.char1 = mbc.sr_instance_code'
36856: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
36857: ||' = NVL(mbc.company_name,'||''''||NULL_CHAR||''''||') '
36858: ||' AND mlis.char3 = mbc.organization_code'

Line 37311: INSERT INTO msc_local_id_setup

37307: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37308:
37309: -- Insert into the LID table
37310:
37311: INSERT INTO msc_local_id_setup
37312: (local_id,
37313: st_transaction_id,
37314: instance_id,
37315: entity_name,

Line 37372: 'UPDATE msc_local_id_setup mlis'

37368: -- Update the DISABLE_DATE to SYSDATE for the deleted component in LID table
37369: v_sql_stmt := 25;
37370: /*
37371: lv_sql_stmt :=
37372: 'UPDATE msc_local_id_setup mlis'
37373: ||' SET date2 = SYSDATE'
37374: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_bom_components mbc'
37375: ||' WHERE mlis.char1 = mbc.sr_instance_code'
37376: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 37402: UPDATE msc_local_id_setup

37398: IF c7%ROWCOUNT > 0 THEN
37399:
37400: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37401:
37402: UPDATE msc_local_id_setup
37403: SET date2 = SYSDATE
37404: WHERE rowid = lb_rowid(j);
37405:
37406: END IF;

Line 37764: ||' FROM msc_local_id_setup mlis'

37760:
37761: lv_sql_stmt:=
37762: 'UPDATE msc_st_component_substitutes mcs'
37763: ||' SET assembly_name = (SELECT char5'
37764: ||' FROM msc_local_id_setup mlis'
37765: ||' WHERE mlis.char1 = mcs.sr_instance_code'
37766: ||' AND mlis.char3 = mcs.organization_code'
37767: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
37768: ||' = NVL(mcs.company_name,'||''''||NULL_CHAR||''''||') '

Line 37885: ||' FROM msc_local_id_setup mlis'

37881:
37882: lv_sql_stmt :=
37883: 'UPDATE msc_st_component_substitutes mcs'
37884: ||' SET component_sequence_id= (SELECT local_id '
37885: ||' FROM msc_local_id_setup mlis'
37886: ||' WHERE mlis.char1 = mcs.sr_instance_code'
37887: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
37888: ||' = NVL(mcs.company_name,'||''''||NULL_CHAR||''''||') '
37889: ||' AND mlis.char3 = mcs.organization_code'

Line 38368: ||' FROM msc_local_id_setup t2'

38364: lv_sql_stmt :=
38365: 'UPDATE MSC_ST_CO_PRODUCTS t1'
38366: ||' SET CO_PRODUCT_GROUP_ID '
38367: ||' = (SELECT local_id'
38368: ||' FROM msc_local_id_setup t2'
38369: ||' WHERE t2.char1 = t1.sr_instance_code'
38370: ||' AND NVL(t2.char2,'||''''||NULL_CHAR||''''||') '
38371: ||' = NVL(t1.company_name,'||''''||NULL_CHAR||''''||') '
38372: ||' AND t2.char4 = t1.COMPONENT_NAME '

Line 38574: INSERT INTO msc_local_id_setup

38570: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
38571:
38572: -- Insert into the LID table with the user defined key
38573:
38574: INSERT INTO msc_local_id_setup
38575: (local_id,
38576: st_transaction_id,
38577: instance_id,
38578: entity_name,

Line 39216: ||' FROM msc_local_id_setup mlis'

39212:
39213: lv_sql_stmt :=
39214: 'UPDATE msc_st_routings msr'
39215: ||' SET line_id = ( SELECT local_id'
39216: ||' FROM msc_local_id_setup mlis'
39217: ||' WHERE mlis.char1 = msr.sr_instance_code'
39218: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
39219: ||' = NVL(msr.company_name,'||''''||NULL_CHAR||''''||') '
39220: ||' AND mlis.char3 = msr.organization_code'

Line 39490: INSERT INTO msc_local_id_setup

39486: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
39487:
39488: -- Insert into the LID table with the user defined key
39489:
39490: INSERT INTO msc_local_id_setup
39491: (local_id,
39492: st_transaction_id,
39493: instance_id,
39494: entity_name,

Line 40009: ||' FROM msc_local_id_setup mlis'

40005: v_sql_stmt := 24;
40006: lv_sql_Stmt :=
40007: 'UPDATE msc_st_routing_operations msro'
40008: ||' SET operation_sequence_id= (SELECT local_id'
40009: ||' FROM msc_local_id_setup mlis'
40010: ||' WHERE mlis.char1 = msro.sr_instance_code'
40011: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
40012: ||' = NVL(msro.company_name,'||''''||NULL_CHAR||''''||') '
40013: ||' AND mlis.char3 = msro.organization_code'

Line 40038: ||' FROM msc_local_id_setup mlis'

40034:
40035: lv_sql_stmt :=
40036: 'UPDATE msc_st_routing_operations msro'
40037: ||' SET operation_seq_num = ( SELECT number1'
40038: ||' FROM msc_local_id_setup mlis'
40039: ||' WHERE local_id = msro.operation_sequence_id'
40040: ||' AND mlis.entity_name = ''OPERATION_SEQUENCE_ID'' '
40041: ||' AND mlis.instance_id = '||v_instance_id||')'
40042: ||' WHERE sr_instance_code = :v_instance_code'

Line 40119: ||' FROM msc_local_id_setup mlis'

40115: v_sql_stmt := 27;
40116: lv_sql_stmt :=
40117: 'UPDATE msc_st_routing_operations msro'
40118: ||' SET department_id= (SELECT local_id'
40119: ||' FROM msc_local_id_setup mlis'
40120: ||' WHERE mlis.char1 = msro.sr_instance_code'
40121: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
40122: ||' = NVL(msro.company_name,'||''''||NULL_CHAR||''''||') '
40123: ||' AND mlis.char3 = msro.organization_code'

Line 40160: INSERT INTO msc_local_id_setup

40156: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40157:
40158: -- Insert into the LID table this new department with the user defined key
40159:
40160: INSERT INTO msc_local_id_setup
40161: (local_id,
40162: st_transaction_id,
40163: instance_id,
40164: entity_name,

Line 40204: ||' FROM msc_local_id_setup mlis'

40200:
40201: lv_sql_stmt :=
40202: 'UPDATE msc_st_routing_operations msdr'
40203: ||' SET department_id= (SELECT local_id'
40204: ||' FROM msc_local_id_setup mlis'
40205: ||' WHERE mlis.char1 = msdr.sr_instance_code'
40206: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
40207: ||' = NVL(msdr.company_name,'||''''||NULL_CHAR||''''||') '
40208: ||' AND mlis.char3 = msdr.organization_code'

Line 40338: INSERT INTO msc_local_id_setup

40334:
40335: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40336: -- Insert into the LID table with the user defined key
40337:
40338: INSERT INTO msc_local_id_setup
40339: (local_id,
40340: st_transaction_id,
40341: instance_id,
40342: entity_name,

Line 40421: ||' msc_local_id_setup mlis'

40417: ||' msro.created_by,'
40418: ||' msro.REFRESH_ID'
40419: ||' FROM msc_st_routing_operations msro,'
40420: ||' msc_st_bom_components msbc,'
40421: ||' msc_local_id_setup mlis'
40422: ||' WHERE msbc.bill_sequence_id = mlis.number1'
40423: ||' AND mlis.entity_name = ''ROUTING_SEQUENCE_ID'' '
40424: ||' AND mlis.local_id = msro.routing_sequence_id'
40425: ||' AND msbc.process_flag = '||G_VALID

Line 40447: ||' msc_local_id_setup mlis,'

40443: ||' msro.created_by,'
40444: ||' msro.REFRESH_ID'
40445: ||' FROM msc_st_routing_operations msro,'
40446: ||' msc_bom_components mbc,'
40447: ||' msc_local_id_setup mlis,'
40448: ||' msc_local_id_setup mlis1'
40449: ||' WHERE mbc.component_sequence_id = mlis1.local_id '
40450: ||' AND mbc.bill_sequence_id = mlis.number1'
40451: ||' AND mbc.sr_instance_id = :v_instance_id'

Line 40448: ||' msc_local_id_setup mlis1'

40444: ||' msro.REFRESH_ID'
40445: ||' FROM msc_st_routing_operations msro,'
40446: ||' msc_bom_components mbc,'
40447: ||' msc_local_id_setup mlis,'
40448: ||' msc_local_id_setup mlis1'
40449: ||' WHERE mbc.component_sequence_id = mlis1.local_id '
40450: ||' AND mbc.bill_sequence_id = mlis.number1'
40451: ||' AND mbc.sr_instance_id = :v_instance_id'
40452: ||' AND mbc.plan_id = -1'

Line 40854: ||' FROM msc_local_id_setup mlis'

40850: v_sql_stmt := 38;
40851: lv_sql_stmt:=
40852: 'UPDATE msc_st_operation_resources msor'
40853: ||' SET operation_sequence_id= (SELECT local_id'
40854: ||' FROM msc_local_id_setup mlis'
40855: ||' WHERE mlis.char1 = msor.sr_instance_code'
40856: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
40857: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
40858: ||' AND mlis.char3 = msor.organization_code'

Line 40994: ||' FROM msc_local_id_setup mlis'

40990: v_sql_stmt := 40;
40991: lv_sql_stmt :=
40992: 'UPDATE msc_st_operation_resources msor'
40993: ||' SET resource_seq_num = (SELECT local_id '
40994: ||' FROM msc_local_id_setup mlis'
40995: ||' WHERE mlis.char1 = msor.sr_instance_code'
40996: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
40997: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
40998: ||' AND mlis.char3 = msor.organization_code'

Line 41055: ||' FROM msc_local_id_setup mlis'

41051:
41052: lv_sql_stmt :=
41053: 'UPDATE msc_st_operation_resources msor'
41054: ||' SET resource_id = (SELECT local_id'
41055: ||' FROM msc_local_id_setup mlis'
41056: ||' WHERE mlis.char1 = msor.sr_instance_code'
41057: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
41058: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
41059: ||' AND mlis.char3 = msor.organization_code'

Line 41078: ||' FROM msc_local_id_setup mlis'

41074:
41075: lv_sql_stmt :=
41076: 'UPDATE msc_st_operation_resources msor'
41077: ||' SET department_id = (SELECT local_id'
41078: ||' FROM msc_local_id_setup mlis'
41079: ||' WHERE mlis.char1 = msor.sr_instance_code'
41080: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
41081: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
41082: ||' AND mlis.char3 = msor.organization_code'

Line 41244: INSERT INTO msc_local_id_setup

41240:
41241: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
41242: -- Insert into the LID table with the user defined key
41243:
41244: INSERT INTO msc_local_id_setup
41245: (local_id,
41246: st_transaction_id,
41247: instance_id,
41248: entity_name,

Line 41304: ||' FROM msc_local_id_setup mlis'

41300: v_sql_stmt := 47;
41301: lv_sql_stmt :=
41302: 'UPDATE msc_st_operation_resources msor'
41303: ||' SET resource_seq_num = (SELECT local_id '
41304: ||' FROM msc_local_id_setup mlis'
41305: ||' WHERE mlis.char1 = msor.sr_instance_code'
41306: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
41307: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
41308: ||' AND mlis.char3 = msor.organization_code'

Line 41916: ||' FROM msc_local_id_setup mlis'

41912: v_sql_stmt := 65;
41913: lv_sql_Stmt :=
41914: 'UPDATE msc_st_operation_networks mson'
41915: ||' SET from_op_seq_id= (SELECT local_id'
41916: ||' FROM msc_local_id_setup mlis'
41917: ||' WHERE mlis.char1 = mson.sr_instance_code'
41918: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
41919: ||' = NVL(mson.company_name,'||''''||NULL_CHAR||''''||') '
41920: ||' AND mlis.char3 = mson.organization_code'

Line 41978: ||' FROM msc_local_id_setup mlis'

41974: v_sql_stmt := 67;
41975: lv_sql_Stmt :=
41976: 'UPDATE msc_st_operation_networks mson'
41977: ||' SET to_op_seq_id= (SELECT local_id'
41978: ||' FROM msc_local_id_setup mlis'
41979: ||' WHERE mlis.char1 = mson.sr_instance_code'
41980: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
41981: ||' = NVL(mson.company_name,'||''''||NULL_CHAR||''''||') '
41982: ||' AND mlis.char3 = mson.organization_code'

Line 43035: ||' FROM msc_local_id_setup mls'

43031: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '
43032: ||' AND mls.char1 = mss.sr_instance_code'
43033: ||' AND mls.entity_name = ''SCHEDULE_GROUP_ID'' ),'
43034: ||' line_id = (SELECT local_id'
43035: ||' FROM msc_local_id_setup mls'
43036: ||' WHERE mls.char4 = mss.line_code'
43037: ||' AND mls.char3 = mss.organization_code'
43038: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
43039: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 43043: ||' FROM msc_local_id_setup mls'

43039: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '
43040: ||' AND mls.char1 = mss.sr_instance_code'
43041: ||' AND mls.entity_name = ''LINE_ID''),'
43042: ||' operation_seq_num = (SELECT number1'
43043: ||' FROM msc_local_id_setup mls'
43044: ||' WHERE mls.char5 = mss.operation_seq_code'
43045: ||' AND mls.char4 = mss.routing_name'
43046: ||' AND NVL(mls.char6, '||''''||NULL_CHAR||''''||') = '
43047: ||' NVL(mss.alternate_routing_designator,'||''''||NULL_CHAR||''''||') '

Line 43181: ||' FROM msc_local_id_setup mls'

43177:
43178: lv_sql_stmt :=
43179: 'UPDATE msc_st_supplies mss'
43180: ||' SET jump_op_seq_num = (SELECT number1'
43181: ||' FROM msc_local_id_setup mls'
43182: ||' WHERE NVL(mls.char5,'||''''||NULL_CHAR||''''||') = '
43183: ||' NVL(mss.jump_op_seq_code,'||''''||NULL_CHAR||''''||') '
43184: ||' AND mls.char4 = mss.routing_name'
43185: ||' AND NVL(mls.char6, '||''''||NULL_CHAR||''''||') = '

Line 43867: ||' FROM msc_local_id_setup mlis'

43863:
43864: lv_sql_stmt :=
43865: 'UPDATE msc_st_resource_requirements msrr'
43866: ||' SET resource_id= (SELECT local_id '
43867: ||' FROM msc_local_id_setup mlis'
43868: ||' WHERE mlis.char1 = msrr.sr_instance_code'
43869: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
43870: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
43871: ||' AND mlis.char3 = msrr.organization_code'

Line 43971: ||' FROM msc_local_id_setup mlis'

43967:
43968: lv_sql_stmt :=
43969: 'UPDATE msc_st_resource_requirements msrr'
43970: ||' SET department_id = (SELECT local_id'
43971: ||' FROM msc_local_id_setup mlis'
43972: ||' WHERE mlis.char1 = msrr.sr_instance_code'
43973: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
43974: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
43975: ||' AND mlis.char3 = msrr.organization_code'

Line 44244: ||' FROM msc_local_id_setup mlis'

44240: v_sql_stmt := 14;
44241: lv_sql_stmt:=
44242: 'UPDATE msc_st_resource_requirements msrr'
44243: ||' SET operation_seq_num = (SELECT number1'
44244: ||' FROM msc_local_id_setup mlis'
44245: ||' WHERE mlis.char1 = msrr.sr_instance_code'
44246: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
44247: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
44248: ||' AND mlis.char3 = msrr.organization_code'

Line 44273: ||' FROM msc_local_id_setup mlis'

44269: v_sql_stmt := 15;
44270: lv_sql_Stmt :=
44271: 'UPDATE msc_st_resource_requirements msrr'
44272: ||' SET operation_sequence_id= (SELECT local_id'
44273: ||' FROM msc_local_id_setup mlis'
44274: ||' WHERE mlis.char1 = msrr.sr_instance_code'
44275: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
44276: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
44277: ||' AND mlis.char3 = msrr.organization_code'

Line 44348: ||' FROM msc_local_id_setup mlis'

44344:
44345: lv_sql_stmt :=
44346: 'UPDATE msc_st_resource_requirements msor'
44347: ||' SET resource_seq_num = (SELECT local_id '
44348: ||' FROM msc_local_id_setup mlis'
44349: ||' WHERE mlis.char1 = msor.sr_instance_code'
44350: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
44351: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
44352: ||' AND mlis.char3 = msor.organization_code'

Line 44508: INSERT INTO msc_local_id_setup

44504:
44505: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44506:
44507: -- Insert into the LID table
44508: INSERT INTO msc_local_id_setup
44509: (local_id,
44510: st_transaction_id,
44511: instance_id,
44512: entity_name,

Line 44570: ||' FROM msc_local_id_setup mlis'

44566: v_sql_stmt := 19;
44567: lv_sql_Stmt :=
44568: 'UPDATE msc_st_resource_requirements msrr'
44569: ||' SET (operation_sequence_id, operation_seq_num) = (SELECT local_id, number1'
44570: ||' FROM msc_local_id_setup mlis'
44571: ||' WHERE mlis.char1 = msrr.sr_instance_code'
44572: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
44573: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
44574: ||' AND mlis.char3 = msrr.organization_code'

Line 44610: INSERT INTO msc_local_id_setup

44606:
44607: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44608: -- Insert into the LID table with the user defined key
44609:
44610: INSERT INTO msc_local_id_setup
44611: (local_id,
44612: st_transaction_id,
44613: instance_id,
44614: entity_name,

Line 44671: ||' FROM msc_local_id_setup mlis'

44667:
44668: lv_sql_stmt :=
44669: 'UPDATE msc_st_resource_requirements msor'
44670: ||' SET resource_seq_num = (SELECT local_id '
44671: ||' FROM msc_local_id_setup mlis'
44672: ||' WHERE mlis.char1 = msor.sr_instance_code'
44673: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
44674: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
44675: ||' AND mlis.char3 = msor.organization_code'

Line 45415: ||' FROM msc_local_id_setup mlis'

45411: v_sql_stmt := 12;
45412: lv_sql_stmt:=
45413: 'UPDATE msc_st_demands msd'
45414: ||' SET operation_seq_num= (SELECT number1'
45415: ||' FROM msc_local_id_setup mlis'
45416: ||' WHERE mlis.char1 = msd.sr_instance_code'
45417: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
45418: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
45419: ||' AND mlis.char3 = msd.organization_code'

Line 45710: INSERT INTO msc_local_id_setup

45706: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
45707:
45708: -- Insert into the LID table
45709:
45710: INSERT INTO msc_local_id_setup
45711: (local_id,
45712: st_transaction_id,
45713: instance_id,
45714: entity_name,

Line 45772: ||' FROM msc_local_id_setup mlis'

45768: v_sql_stmt := 12;
45769: lv_sql_stmt:=
45770: 'UPDATE msc_st_demands msd'
45771: ||' SET operation_seq_num= (SELECT number1'
45772: ||' FROM msc_local_id_setup mlis'
45773: ||' WHERE mlis.char1 = msd.sr_instance_code'
45774: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
45775: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
45776: ||' AND mlis.char3 = msd.organization_code'

Line 46545: ||' FROM msc_local_id_setup mlis'

46541: v_sql_stmt := 16;
46542: lv_sql_Stmt :=
46543: 'UPDATE msc_st_job_operation_networks mson'
46544: ||' SET (from_op_seq_id, from_op_seq_num) = (SELECT local_id, number1'
46545: ||' FROM msc_local_id_setup mlis'
46546: ||' WHERE mlis.char1 = mson.sr_instance_code'
46547: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
46548: ||' = NVL(mson.company_name,'||''''||NULL_CHAR||''''||') '
46549: ||' AND mlis.char3 = mson.organization_code'

Line 46607: ||' FROM msc_local_id_setup mlis'

46603: v_sql_stmt := 18;
46604: lv_sql_Stmt :=
46605: 'UPDATE msc_st_job_operation_networks mson'
46606: ||' SET (to_op_seq_id, to_op_seq_num) = (SELECT local_id, number1'
46607: ||' FROM msc_local_id_setup mlis'
46608: ||' WHERE mlis.char1 = mson.sr_instance_code'
46609: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
46610: ||' = NVL(mson.company_name,'||''''||NULL_CHAR||''''||') '
46611: ||' AND mlis.char3 = mson.organization_code'

Line 47303: ||' FROM msc_local_id_setup mlis'

47299: v_sql_stmt := 18;
47300: lv_sql_Stmt :=
47301: 'UPDATE msc_st_job_operations mson'
47302: ||' SET (operation_sequence_id, operation_seq_num) = (SELECT local_id, number1'
47303: ||' FROM msc_local_id_setup mlis'
47304: ||' WHERE mlis.char1 = mson.sr_instance_code'
47305: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
47306: ||' = NVL(mson.company_name,'||''''||NULL_CHAR||''''||') '
47307: ||' AND mlis.char3 = mson.organization_code'

Line 47363: ||' FROM msc_local_id_setup mlis'

47359: v_sql_stmt := 27;
47360: lv_sql_stmt :=
47361: 'UPDATE msc_st_job_operations msro'
47362: ||' SET department_id= (SELECT local_id'
47363: ||' FROM msc_local_id_setup mlis'
47364: ||' WHERE mlis.char1 = msro.sr_instance_code'
47365: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
47366: ||' = NVL(msro.company_name,'||''''||NULL_CHAR||''''||') '
47367: ||' AND mlis.char3 = msro.organization_code'

Line 48129: ||' FROM msc_local_id_setup mlis'

48125: v_sql_stmt := 12;
48126: lv_sql_stmt:=
48127: 'UPDATE msc_st_job_requirement_ops msd'
48128: ||' SET operation_seq_num= (SELECT number1'
48129: ||' FROM msc_local_id_setup mlis'
48130: ||' WHERE mlis.char1 = msd.sr_instance_code'
48131: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48132: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
48133: ||' AND mlis.char3 = msd.organization_code'

Line 48187: ||' FROM msc_local_id_setup mlis'

48183:
48184: lv_sql_stmt :=
48185: 'UPDATE msc_st_job_requirement_ops mjro'
48186: ||' SET component_sequence_id= (SELECT local_id '
48187: ||' FROM msc_local_id_setup mlis'
48188: ||' WHERE mlis.char1 = mjro.sr_instance_code'
48189: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48190: ||' = NVL(mjro.company_name,'||''''||NULL_CHAR||''''||') '
48191: ||' AND mlis.char3 = mjro.organization_code'

Line 48244: ||' FROM msc_local_id_setup mlis'

48240:
48241: lv_sql_stmt :=
48242: 'UPDATE msc_st_job_requirement_ops mjro'
48243: ||' SET department_id= (SELECT local_id'
48244: ||' FROM msc_local_id_setup mlis'
48245: ||' WHERE mlis.char1 = mjro.sr_instance_code'
48246: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48247: ||' = NVL(mjro.company_name,'||''''||NULL_CHAR||''''||') '
48248: ||' AND mlis.char3 = mjro.organization_code'

Line 48597: ||' FROM msc_local_id_setup mlis'

48593:
48594: lv_sql_stmt :=
48595: 'UPDATE msc_st_job_op_resources msrr'
48596: ||' SET resource_id= (SELECT local_id '
48597: ||' FROM msc_local_id_setup mlis'
48598: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48599: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48600: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
48601: ||' AND mlis.char3 = msrr.organization_code'

Line 48660: ||' FROM msc_local_id_setup mlis'

48656: v_sql_stmt := 25;
48657: lv_sql_stmt :=
48658: 'UPDATE msc_st_job_op_resources msrs'
48659: ||' SET department_id = (SELECT local_id'
48660: ||' FROM msc_local_id_setup mlis'
48661: ||' WHERE mlis.char1 = msrs.sr_instance_code'
48662: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48663: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '
48664: ||' AND mlis.char3 = msrs.organization_code'

Line 48893: ||' FROM msc_local_id_setup mlis'

48889: v_sql_stmt := 14;
48890: lv_sql_stmt:=
48891: 'UPDATE msc_st_job_op_resources msrr'
48892: ||' SET operation_seq_num = (SELECT number1'
48893: ||' FROM msc_local_id_setup mlis'
48894: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48895: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48896: ||' = NVL(msrr.company_name,'||''''||NULL_CHAR||''''||') '
48897: ||' AND mlis.char3 = msrr.organization_code'

Line 48988: ||' FROM msc_local_id_setup mlis'

48984:
48985: lv_sql_stmt :=
48986: 'UPDATE msc_st_job_op_resources msor'
48987: ||' SET resource_seq_num = (SELECT local_id '
48988: ||' FROM msc_local_id_setup mlis'
48989: ||' WHERE mlis.char1 = msor.sr_instance_code'
48990: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
48991: ||' = NVL(msor.company_name,'||''''||NULL_CHAR||''''||') '
48992: ||' AND mlis.char3 = msor.organization_code'

Line 52515: ||' FROM msc_local_id_setup '

52511: lv_sql_stmt :=
52512: 'UPDATE msc_st_apps_instances mai'
52513: ||' SET validation_org_id'
52514: ||' = (SELECT local_id'
52515: ||' FROM msc_local_id_setup '
52516: ||' WHERE char1 = sr_instance_code'
52517: ||' AND char3 = msc_org_for_bom_explosion'
52518: ||' AND number1 = '|| G_ORGANIZATION
52519: ||' AND entity_name = ''SR_TP_ID'' )'