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_DEMAND_ODS_LOAD dependencies on MSC_DEMANDS

Line 595: lv_tbl:= 'MSC_DEMANDS';

591: msc_analyse_tables_pk.analyse_table( 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
592:
593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
594: ELSE
595: lv_tbl:= 'MSC_DEMANDS';
596: END IF;
597:
598: /* select the link_to_line_id and its corresponding demand_id into Collection variables */
599:

Line 751: lv_tbl:= 'MSC_DEMANDS';

747:
748: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
749: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
750: ELSE
751: lv_tbl:= 'MSC_DEMANDS';
752: END IF;
753:
754: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
755: BEGIN

Line 796: ||' MSC_DEMANDS_S.nextval,'

792: ||' CREATION_DATE,'
793: ||' CREATED_BY) '
794: ||' SELECT '
795: ||' -1,'
796: ||' MSC_DEMANDS_S.nextval,'
797: ||' msd.demand_type,'
798: ||' msd.ORIGINATION_TYPE,'
799: ||' t1.INVENTORY_ITEM_ID,'
800: ||' msd.ORGANIZATION_ID,'

Line 859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

855:
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
863: RAISE;

Line 870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
873: END IF;
874: END;

Line 917: ||' MSC_DEMANDS_S.nextval,'

913: ||' CREATION_DATE,'
914: ||' CREATED_BY) '
915: ||'VALUES'
916: ||'( -1,'
917: ||' MSC_DEMANDS_S.nextval,'
918: ||' :DEMAND_TYPE,'
919: ||' :ORIGINATION_TYPE,'
920: ||' :INVENTORY_ITEM_ID,'
921: ||' :ORGANIZATION_ID,'

Line 958: DELETE MSC_DEMANDS

954:
955: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
956: FOR c_rec in c1_d LOOP
957:
958: DELETE MSC_DEMANDS
959: WHERE PLAN_ID= -1
960: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
961: AND ORIGINATION_TYPE= c_rec.ORIGINATION_TYPE
962: AND SALES_ORDER_LINE_ID = c_rec.SALES_ORDER_LINE_ID

Line 975: UPDATE MSC_DEMANDS

971: BEGIN
972:
973: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
974: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
975: UPDATE MSC_DEMANDS
976: SET
977: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
978: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
979: OLD_USING_REQUIREMENT_QUANTITY= USING_REQUIREMENT_QUANTITY,

Line 1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1062:
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: RAISE;

Line 1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1074:
1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 1615: defined as varchar(62) in msc_demands table */

1611: -- ==============================================================
1612: PROCEDURE LOAD_DEMAND IS
1613:
1614: /* 2201791 - select substr(order_number,1,62) since order_number is
1615: defined as varchar(62) in msc_demands table */
1616:
1617: CURSOR c1 IS
1618: SELECT
1619: t1.INVENTORY_ITEM_ID,

Line 1748: lv_tbl:= 'MSC_DEMANDS';

1744: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1745: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1746: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1747: ELSE
1748: lv_tbl:= 'MSC_DEMANDS';
1749: lv_supply_tbl:= 'MSC_SUPPLIES';
1750: END IF;
1751:
1752: /** PREPLACE CHANGE START **/

Line 1838: ||' MSC_DEMANDS_S.nextval,'

1834: ||' SHIP_TO_LOCATION_ID,'
1835: ||' SHIPPING_METHOD_CODE)'
1836: ||'VALUES'
1837: ||'( -1,'
1838: ||' MSC_DEMANDS_S.nextval,'
1839: ||' :INVENTORY_ITEM_ID,'
1840: ||' :ORGANIZATION_ID,'
1841: ||' :SCHEDULE_DESIGNATOR_ID,'
1842: ||' :USING_ASSEMBLY_ITEM_ID,'

Line 2036: UPDATE MSC_DEMANDS

2032: IF lb_ORIGINATION_TYPE(j) IN ( 6,7,15,24,42) THEN
2033:
2034: IF lb_DELETED_FLAG(j) = MSC_UTIL.SYS_YES THEN
2035:
2036: UPDATE MSC_DEMANDS
2037: SET USING_REQUIREMENT_QUANTITY= 0,
2038: DAILY_DEMAND_RATE= 0,
2039: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2040: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 2051: UPDATE MSC_DEMANDS

2047:
2048: ELSE
2049:
2050: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
2051: UPDATE MSC_DEMANDS
2052: SET
2053: INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
2054: ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
2055: OLD_USING_REQUIREMENT_QUANTITY= lb_USING_REQUIREMENT_QUANTITY(j),

Line 2108: UPDATE MSC_DEMANDS

2104: ELSIF lb_ORIGINATION_TYPE(j)=8 THEN /* Manual MDS */
2105:
2106: IF lb_DELETED_FLAG(j)= MSC_UTIL.SYS_YES THEN
2107:
2108: UPDATE MSC_DEMANDS
2109: SET USING_REQUIREMENT_QUANTITY= 0,
2110: DAILY_DEMAND_RATE= 0,
2111: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2112: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 2123: UPDATE MSC_DEMANDS

2119:
2120: ELSE
2121:
2122: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
2123: UPDATE MSC_DEMANDS
2124: SET
2125: INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
2126: ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
2127: OLD_USING_REQUIREMENT_QUANTITY= lb_USING_REQUIREMENT_QUANTITY(j),

Line 2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

2249:
2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2257: RAISE;

Line 2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

2262:
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 2314: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS

2310: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN COMMIT; END IF;
2311:
2312: IF (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) then
2313: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR (MSC_CL_COLLECTION.v_is_cont_refresh and MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN --Version
2314: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS
2315: if mds is incremental*/
2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;
2317: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');

Line 2606: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';

2602: nvl('''||MSC_CL_COLLECTION.v_source_sr_instance_id||''','''||MSC_CL_COLLECTION.v_instance_id||''')
2603:
2604: ';
2605: lv_sql1_2 :=
2606: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';
2607:
2608: lv_sql1_3:='
2609: FROM MSC_ITEM_ID_LID t1,
2610: MSC_ITEM_ID_LID t2,

Line 2862: MSC_DEMANDS_S.nextval

2858: s.ITEM_TYPE_ID,
2859: s.ITEM_TYPE_VALUE,
2860: s.SOURCE_ORGANIZATION_ID,
2861: nvl('''||MSC_CL_COLLECTION.v_source_sr_instance_id||''','''||MSC_CL_COLLECTION.v_instance_id||'''),
2862: MSC_DEMANDS_S.nextval
2863:
2864: ) ';
2865:
2866:

Line 3611: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS '

3607:
3608: lv_temp_demand_tbl := 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
3609: lv_sql_stmt:=
3610: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3611: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS '
3612: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3613: ||' AND plan_id = -1 '
3614: ||' AND (' ;--( origination_type NOT IN (';
3615:

Line 3802: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';

3798:
3799: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3800:
3801: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3802: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3803:
3804: EXECUTE IMMEDIATE lv_sql_stmt2;
3805:
3806: Commit ;

Line 3812: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';

3808:
3809: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3810:
3811: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3812: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3813:
3814: EXECUTE IMMEDIATE lv_sql_stmt2;
3815:
3816: Commit ;

Line 3848: || ' SELECT * from MSC_DEMANDS '

3844:
3845: lv_copySQL_fixedpart :=
3846: 'INSERT INTO '
3847: || lv_temp_demand_tbl
3848: || ' SELECT * from MSC_DEMANDS '
3849: || ' WHERE sr_instance_id = '
3850: || MSC_CL_COLLECTION.v_instance_id
3851: || ' AND plan_id = -1 '; -- ||' AND ( origination_type NOT IN (';
3852:

Line 4136: || ' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '

4132: THEN
4133: lv_sql_stmt2 :=
4134: 'INSERT INTO '
4135: || lv_temp_demand_tbl
4136: || ' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '
4137: || MSC_UTIL.v_depot_org_str
4138: || ' and sr_instance_id = '
4139: || MSC_CL_COLLECTION.v_instance_id
4140: || ' and plan_id = -1 ';

Line 4156: || ' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '

4152: THEN
4153: lv_sql_stmt2 :=
4154: 'INSERT INTO '
4155: || lv_temp_demand_tbl
4156: || ' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '
4157: || MSC_UTIL.v_non_depot_org_str
4158: || ' and sr_instance_id = '
4159: || MSC_CL_COLLECTION.v_instance_id
4160: || ' and plan_id = -1 ';

Line 4185: lv_tbl:= 'MSC_DEMANDS';

4181:
4182: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4183: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
4184: ELSE
4185: lv_tbl:= 'MSC_DEMANDS';
4186: END IF;
4187:
4188:
4189: lv_sql_ins :=

Line 4210: MSC_DEMANDS_S.nextval,

4206: CREATION_DATE,
4207: CREATED_BY)
4208: SELECT
4209: -1 PLAN_ID,
4210: MSC_DEMANDS_S.nextval,
4211: MOP. QUANTITY,
4212: SCHEDULED_PAYBACK_DATE,
4213: 1 DEMAND_TYPE,
4214: 27 ORIGINATION_TYPE,