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_DESIGNATORS

Line 638: from the msc_designators, becasue the customer inform can be entered at the Forecast level on the source */

634: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
635: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;
636:
637: /* for bug: 2351354, made the changes to cursor to select the customer_id and the ship_to_site_id
638: from the msc_designators, becasue the customer inform can be entered at the Forecast level on the source */
639:
640: CURSOR c1 IS
641: SELECT
642: t1.INVENTORY_ITEM_ID,

Line 674: MSC_DESIGNATORS md,

670: FROM
671: -- msc_tp_id_lid c1,
672: MSC_ITEM_ID_LID t1,
673: MSC_ITEM_ID_LID t2,
674: MSC_DESIGNATORS md,
675: MSC_ST_DEMANDS msd
676: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
677: AND t1.sr_instance_id= msd.sr_instance_id
678: AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id)

Line 779: ||' MSC_DESIGNATORS md, '

775: ||' :v_current_user '
776: ||' FROM '
777: ||' MSC_ITEM_ID_LID t1, '
778: ||' MSC_ITEM_ID_LID t2, '
779: ||' MSC_DESIGNATORS md, '
780: ||' MSC_ST_DEMANDS msd '
781: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '
782: ||' AND t1.sr_instance_id= msd.sr_instance_id '
783: ||' AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id) '

Line 1130: UPDATE MSC_DESIGNATORS

1126:
1127:
1128: FOR c_rec in c1_d loop
1129:
1130: UPDATE MSC_DESIGNATORS
1131: SET DISABLE_DATE= TRUNC(MSC_CL_COLLECTION.v_current_date),
1132: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1133: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1134: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 1160: from msc_designators

1156:
1157: Begin
1158: Select distinct designator_id
1159: into v_forecast_set_id
1160: from msc_designators
1161: where designator = c_rec.forecast_Set
1162: and organization_id = c_rec.organization_id
1163: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1164: Exception

Line 1167: Select MSC_DESIGNATORS_S.Nextval

1163: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1164: Exception
1165: when no_data_found
1166: then
1167: Select MSC_DESIGNATORS_S.Nextval
1168: into v_forecast_set_id
1169: from dual;
1170: End;
1171: Elsif c_rec.forecast_set is null then

Line 1177: UPDATE MSC_DESIGNATORS

1173: v_forecast_set_id := null;
1174: End if;
1175:
1176:
1177: UPDATE MSC_DESIGNATORS
1178: SET
1179: SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id,
1180: forecast_set_id = v_forecast_set_id,
1181: MPS_RELIEF= c_rec.MPS_RELIEF,

Line 1209: INSERT INTO MSC_DESIGNATORS

1205: IF SQL%NOTFOUND THEN
1206:
1207:
1208:
1209: INSERT INTO MSC_DESIGNATORS
1210: ( DESIGNATOR_ID,
1211: FORECAST_SET_ID,
1212: DESIGNATOR,
1213: DESIGNATOR_TYPE,

Line 1238: ( MSC_DESIGNATORS_S.NEXTVAL,

1234: LAST_UPDATED_BY,
1235: CREATION_DATE,
1236: CREATED_BY)
1237: VALUES
1238: ( MSC_DESIGNATORS_S.NEXTVAL,
1239: v_forecast_Set_id,
1240: c_rec.DESIGNATOR,
1241: 6,
1242: c_rec.ORGANIZATION_ID,

Line 1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

1281:
1282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1283: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1284: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1287:
1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1289: RAISE;

Line 1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

1293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1294: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1295: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

Line 1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

1310:
1311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1312: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 1396: MSC_DESIGNATORS md,

1392: FROM
1393: msc_tp_id_lid c1,
1394: MSC_ITEM_ID_LID t1,
1395: MSC_ITEM_ID_LID t2,
1396: MSC_DESIGNATORS md,
1397: MSC_TP_SITE_ID_LID mtsil,
1398: MSC_ST_DEMANDS msd
1399: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
1400: AND t1.sr_instance_id= msd.sr_instance_id

Line 3070: /*UPDATE MSC_DESIGNATORS

3066:
3067:
3068: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3069:
3070: /*UPDATE MSC_DESIGNATORS
3071: SET DISABLE_DATE= MSC_CL_COLLECTION.v_current_date,
3072: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
3073: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3074: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 3080: lv_sql_stmt:= 'UPDATE MSC_DESIGNATORS '

3076: AND designator_type <> 6 -- Added This condition for Bug# 2022521
3077: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES; */
3078:
3079:
3080: lv_sql_stmt:= 'UPDATE MSC_DESIGNATORS '
3081: ||' SET DISABLE_DATE = :v_current_date, '
3082: ||' REFRESH_NUMBER = :v_last_collection_id, '
3083: ||' LAST_UPDATE_DATE= :v_current_date, '
3084: ||' LAST_UPDATED_BY = :v_current_user '

Line 3122: UPDATE MSC_DESIGNATORS

3118: FOR c_rec IN c1 LOOP
3119:
3120: BEGIN
3121:
3122: UPDATE MSC_DESIGNATORS
3123: SET
3124: SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id,
3125: MPS_RELIEF= c_rec.MPS_RELIEF,
3126: INVENTORY_ATP_FLAG= c_rec.INVENTORY_ATP_FLAG,

Line 3144: INSERT INTO MSC_DESIGNATORS

3140: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
3141:
3142: IF SQL%NOTFOUND THEN
3143:
3144: INSERT INTO MSC_DESIGNATORS
3145: ( DESIGNATOR_ID,
3146: DESIGNATOR,
3147: ORGANIZATION_ID,
3148: MPS_RELIEF,

Line 3165: ( MSC_DESIGNATORS_S.NEXTVAL,

3161: LAST_UPDATED_BY,
3162: CREATION_DATE,
3163: CREATED_BY)
3164: VALUES
3165: ( MSC_DESIGNATORS_S.NEXTVAL,
3166: c_rec.DESIGNATOR,
3167: c_rec.ORGANIZATION_ID,
3168: c_rec.MPS_RELIEF,
3169: c_rec.INVENTORY_ATP_FLAG,

Line 3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

3198:
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3204:
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3206: RAISE;

Line 3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

3210:
3211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3212: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');