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.MSD_CL_PRE_PROCESS dependencies on MSD_LEVEL_VALUES

Line 236: select count(*) from MSD_LEVEL_VALUES

232: lv_error_text VARCHAR2(250);
233: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
234:
235: cursor c1 (p_instance varchar2) is
236: select count(*) from MSD_LEVEL_VALUES
237: where LEVEL_ID = 2
238: and instance = p_instance
239: and SR_LEVEL_PK = to_char(v_null_pk); --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
240:

Line 1973: -- Derive SR_PARENT_LEVEL_PK from msd_level_values or msd_st_level_values

1969: IF lv_return <> 0 THEN
1970: RAISE ex_logging_err;
1971: END IF;
1972:
1973: -- Derive SR_PARENT_LEVEL_PK from msd_level_values or msd_st_level_values
1974:
1975: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
1976: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
1977: p_level_val_col => 'SR_PARENT_LEVEL_VALUE',

Line 2150: select count(*) from MSD_LEVEL_VALUES

2146: AND sr_instance_code = p_instance_code
2147: AND batch_id = p_batch_id;
2148:
2149: cursor c3 (p_instance varchar2) is
2150: select count(*) from MSD_LEVEL_VALUES
2151: where LEVEL_ID = 34
2152: and instance = p_instance
2153: and SR_LEVEL_PK = to_char(v_null_pk); --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
2154:

Line 2441: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

2437: IF lv_return <> 0 THEN
2438: RAISE ex_logging_err;
2439: END IF;
2440:
2441: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
2442:
2443: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2444: (p_table_name => 'MSD_ST_BOOKING_DATA',
2445: p_column_name => 'ITEM',

Line 2491: -- Derive SR_ORIGINAL_ITEM_PK from msd_st_level_values and msd_level_values

2487: IF lv_return <> 0 THEN
2488: RAISE ex_logging_err;
2489: END IF;
2490:
2491: -- Derive SR_ORIGINAL_ITEM_PK from msd_st_level_values and msd_level_values
2492:
2493: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2494: (p_table_name => 'MSD_ST_BOOKING_DATA',
2495: p_column_name => 'ORIGINAL_ITEM',

Line 2522: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values

2518: IF lv_return <> 0 THEN
2519: RAISE ex_logging_err;
2520: END IF;
2521:
2522: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
2523:
2524: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2525: (p_table_name => 'MSD_ST_BOOKING_DATA',
2526: p_column_name => 'INV_ORG',

Line 2603: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values

2599: IF lv_return <> 0 THEN
2600: RAISE ex_logging_err;
2601: END IF;
2602:
2603: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
2604:
2605: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2606: (p_table_name => 'MSD_ST_BOOKING_DATA',
2607: p_column_name => 'CUSTOMER',

Line 2632: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values

2628:
2629: IF lv_return <> 0 THEN
2630: RAISE ex_logging_err;
2631: END IF;
2632: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
2633:
2634: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2635: (p_table_name => 'MSD_ST_BOOKING_DATA',
2636: p_column_name => 'SHIP_TO_LOC',

Line 2711: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

2707: IF lv_return <> 0 THEN
2708: RAISE ex_logging_err;
2709: END IF;
2710:
2711: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
2712:
2713: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2714: (p_table_name => 'MSD_ST_BOOKING_DATA',
2715: p_column_name => 'SALES_CHANNEL',

Line 2741: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

2737:
2738: IF lv_return <> 0 THEN
2739: RAISE ex_logging_err;
2740: END IF;
2741: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
2742:
2743: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2744: (p_table_name => 'MSD_ST_BOOKING_DATA',
2745: p_column_name => 'SALES_REP',

Line 2773: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

2769: IF lv_return <> 0 THEN
2770: RAISE ex_logging_err;
2771: END IF;
2772:
2773: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
2774:
2775: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2776: (p_table_name => 'MSD_ST_BOOKING_DATA',
2777: p_column_name => 'DEMAND_CLASS_LVL_VAL',

Line 2806: -- Derive sr_parent_item_pk from msd_st_level_values and msd_level_values

2802: IF lv_return <> 0 THEN
2803: RAISE ex_logging_err;
2804: END IF;
2805:
2806: -- Derive sr_parent_item_pk from msd_st_level_values and msd_level_values
2807:
2808: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2809: (p_table_name => 'MSD_ST_BOOKING_DATA',
2810: p_column_name => 'PARENT_ITEM',

Line 3039: select count(*) from MSD_LEVEL_VALUES

3035: AND sr_instance_code = p_instance_code
3036: AND batch_id = p_batch_id;
3037:
3038: cursor c3 (p_instance varchar2) is
3039: select count(*) from MSD_LEVEL_VALUES
3040: where LEVEL_ID = 34
3041: and instance = p_instance
3042: and SR_LEVEL_PK = to_char(v_null_pk); --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
3043:

Line 3331: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

3327: IF lv_return <> 0 THEN
3328: RAISE ex_logging_err;
3329: END IF;
3330:
3331: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
3332:
3333: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3334: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3335: p_column_name => 'ITEM',

Line 3383: -- Derive sr_original_item_pk from msd_st_level_values and msd_level_values

3379: IF lv_return <> 0 THEN
3380: RAISE ex_logging_err;
3381: END IF;
3382:
3383: -- Derive sr_original_item_pk from msd_st_level_values and msd_level_values
3384:
3385: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3386: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3387: p_column_name => 'ORIGINAL_ITEM',

Line 3414: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values

3410: IF lv_return <> 0 THEN
3411: RAISE ex_logging_err;
3412: END IF;
3413:
3414: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
3415:
3416: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3417: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3418: p_column_name => 'INV_ORG',

Line 3494: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values

3490: IF lv_return <> 0 THEN
3491: RAISE ex_logging_err;
3492: END IF;
3493:
3494: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
3495:
3496: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3497: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3498: p_column_name => 'CUSTOMER',

Line 3524: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values

3520: IF lv_return <> 0 THEN
3521: RAISE ex_logging_err;
3522: END IF;
3523:
3524: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
3525:
3526: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3527: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3528: p_column_name => 'SHIP_TO_LOC',

Line 3600: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

3596: IF lv_return <> 0 THEN
3597: RAISE ex_logging_err;
3598: END IF;
3599:
3600: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
3601:
3602: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3603: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3604: p_column_name => 'SALES_CHANNEL',

Line 3630: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

3626:
3627: IF lv_return <> 0 THEN
3628: RAISE ex_logging_err;
3629: END IF;
3630: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3631:
3632: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3633: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3634: p_column_name => 'SALES_REP',

Line 3661: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

3657:
3658: IF lv_return <> 0 THEN
3659: RAISE ex_logging_err;
3660: END IF;
3661: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3662:
3663: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3664: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3665: p_column_name => 'DEMAND_CLASS_LVL_VAL',

Line 3692: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

3688:
3689: IF lv_return <> 0 THEN
3690: RAISE ex_logging_err;
3691: END IF;
3692: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3693:
3694: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3695: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3696: p_column_name => 'PARENT_ITEM',

Line 3927: select count(*) from MSD_LEVEL_VALUES

3923: AND sr_instance_code = p_instance_code
3924: AND batch_id = p_batch_id;
3925:
3926: cursor c3 (p_instance varchar2) is -- This cursor is added to find whether the level value 'Others' exist at 'Demand Class' Level. --Bug 3749959
3927: select count(*) from MSD_LEVEL_VALUES
3928: where LEVEL_ID = 34
3929: and instance = p_instance
3930: and SR_LEVEL_PK = to_char(v_null_pk);
3931:

Line 4175: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

4171: IF lv_return <> 0 THEN
4172: RAISE ex_logging_err;
4173: END IF;
4174:
4175: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
4176:
4177: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4178: (p_table_name => 'MSD_ST_MFG_FORECAST',
4179: p_column_name => 'ITEM',

Line 4204: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values

4200: IF lv_return <> 0 THEN
4201: RAISE ex_logging_err;
4202: END IF;
4203:
4204: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
4205:
4206: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4207: (p_table_name => 'MSD_ST_MFG_FORECAST',
4208: p_column_name => 'INV_ORG',

Line 4234: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values

4230: IF lv_return <> 0 THEN
4231: RAISE ex_logging_err;
4232: END IF;
4233:
4234: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
4235:
4236: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4237: (p_table_name => 'MSD_ST_MFG_FORECAST',
4238: p_column_name => 'CUSTOMER',

Line 4263: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values

4259:
4260: IF lv_return <> 0 THEN
4261: RAISE ex_logging_err;
4262: END IF;
4263: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
4264:
4265: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4266: (p_table_name => 'MSD_ST_MFG_FORECAST',
4267: p_column_name => 'SHIP_TO_LOC',

Line 4293: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

4289: IF lv_return <> 0 THEN
4290: RAISE ex_logging_err;
4291: END IF;
4292:
4293: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
4294:
4295: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4296: (p_table_name => 'MSD_ST_MFG_FORECAST',
4297: p_column_name => 'SALES_CHANNEL',

Line 4324: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

4320: IF lv_return <> 0 THEN
4321: RAISE ex_logging_err;
4322: END IF;
4323:
4324: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
4325:
4326: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4327: (p_table_name => 'MSD_ST_MFG_FORECAST',
4328: p_column_name => 'DEMAND_CLASS_LVL_VAL',

Line 6107: -- Derive SR_LEVEL_PK - attribute_3 from msd_level_values

6103: IF lv_return <> 0 THEN
6104: RAISE ex_logging_err;
6105: END IF;
6106:
6107: -- Derive SR_LEVEL_PK - attribute_3 from msd_level_values
6108: -- or msd_st_level_values
6109:
6110: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6111: (p_table_name => 'MSD_ST_CS_DATA',

Line 6170: -- Derive SR_LEVEL_PK - attribute_7 from msd_level_values

6166: IF lv_return <> 0 THEN
6167: RAISE ex_logging_err;
6168: END IF;
6169:
6170: -- Derive SR_LEVEL_PK - attribute_7 from msd_level_values
6171: -- or msd_st_level_values
6172:
6173: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6174: (p_table_name => 'MSD_ST_CS_DATA',

Line 6233: -- Derive SR_LEVEL_PK - attribute_11 from msd_level_values

6229: IF lv_return <> 0 THEN
6230: RAISE ex_logging_err;
6231: END IF;
6232:
6233: -- Derive SR_LEVEL_PK - attribute_11 from msd_level_values
6234: -- or msd_st_level_values
6235:
6236: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6237: (p_table_name => 'MSD_ST_CS_DATA',

Line 6314: -- Derive SR_LEVEL_PK - attribute_15 from msd_level_values

6310: IF lv_return <> 0 THEN
6311: RAISE ex_logging_err;
6312: END IF;
6313:
6314: -- Derive SR_LEVEL_PK - attribute_15 from msd_level_values
6315: -- or msd_st_level_values
6316:
6317: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6318: (p_table_name => 'MSD_ST_CS_DATA',

Line 6379: -- Derive SR_LEVEL_PK - attribute_19 from msd_level_values

6375: IF lv_return <> 0 THEN
6376: RAISE ex_logging_err;
6377: END IF;
6378:
6379: -- Derive SR_LEVEL_PK - attribute_19 from msd_level_values
6380: -- or msd_st_level_values
6381:
6382: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6383: (p_table_name => 'MSD_ST_CS_DATA',

Line 6442: -- Derive SR_LEVEL_PK - attribute_23 from msd_level_values

6438: IF lv_return <> 0 THEN
6439: RAISE ex_logging_err;
6440: END IF;
6441:
6442: -- Derive SR_LEVEL_PK - attribute_23 from msd_level_values
6443: -- or msd_st_level_values
6444:
6445: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6446: (p_table_name => 'MSD_ST_CS_DATA',

Line 6505: -- Derive SR_LEVEL_PK - attribute_27 from msd_level_values

6501: IF lv_return <> 0 THEN
6502: RAISE ex_logging_err;
6503: END IF;
6504:
6505: -- Derive SR_LEVEL_PK - attribute_27 from msd_level_values
6506: -- or msd_st_level_values
6507:
6508: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6509: (p_table_name => 'MSD_ST_CS_DATA',

Line 6567: -- Derive SR_LEVEL_PK - attribute_31 from msd_level_values

6563: IF lv_return <> 0 THEN
6564: RAISE ex_logging_err;
6565: END IF;
6566:
6567: -- Derive SR_LEVEL_PK - attribute_31 from msd_level_values
6568: -- or msd_st_level_values
6569:
6570: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6571: (p_table_name => 'MSD_ST_CS_DATA',

Line 6630: -- Derive SR_LEVEL_PK - attribute_51 from msd_level_values

6626: IF lv_return <> 0 THEN
6627: RAISE ex_logging_err;
6628: END IF;
6629:
6630: -- Derive SR_LEVEL_PK - attribute_51 from msd_level_values
6631: -- or msd_st_level_values
6632:
6633: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6634: (p_table_name => 'MSD_ST_CS_DATA',

Line 7646: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

7642: IF lv_return <> 0 THEN
7643: RAISE ex_logging_err;
7644: END IF;
7645:
7646: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
7647:
7648: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
7649: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',
7650: p_column_name => 'ITEM',

Line 7999: -- Derive INVENTORY_ITEM_ID from msd_st_level_values and msd_level_values

7995: IF lv_return <> 0 THEN
7996: RAISE ex_logging_err;
7997: END IF;
7998:
7999: -- Derive INVENTORY_ITEM_ID from msd_st_level_values and msd_level_values
8000:
8001: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
8002: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8003: p_column_name => 'INVENTORY_ITEM',

Line 8030: -- Derive RELATED_ITEM_ID from msd_st_level_values and msd_level_values

8026: IF lv_return <> 0 THEN
8027: RAISE ex_logging_err;
8028: END IF;
8029:
8030: -- Derive RELATED_ITEM_ID from msd_st_level_values and msd_level_values
8031:
8032: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
8033: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8034: p_column_name => 'RELATED_ITEM',

Line 8380: -- Derive SR_LEVEL_PK from msd_level_values or msd_st_level_values

8376: IF lv_return <> 0 THEN
8377: RAISE ex_logging_err;
8378: END IF;
8379:
8380: -- Derive SR_LEVEL_PK from msd_level_values or msd_st_level_values
8381:
8382: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
8383: (p_table_name => 'MSD_ST_LEVEL_ORG_ASSCNS',
8384: p_level_val_col => 'LEVEL_VALUE',

Line 8410: -- Derive ORG_SR_LEVEL_PK from msd_level_values or msd_st_level_values

8406: IF lv_return <> 0 THEN
8407: RAISE ex_logging_err;
8408: END IF;
8409:
8410: -- Derive ORG_SR_LEVEL_PK from msd_level_values or msd_st_level_values
8411:
8412: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
8413: (p_table_name => 'MSD_ST_LEVEL_ORG_ASSCNS',
8414: p_level_val_col => 'ORG_LEVEL_VALUE',