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 686: from the msc_designators, becasue the customer inform can be entered at the Forecast level on the source */

682: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
683: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;
684:
685: /* for bug: 2351354, made the changes to cursor to select the customer_id and the ship_to_site_id
686: from the msc_designators, becasue the customer inform can be entered at the Forecast level on the source */
687:
688: CURSOR c1 IS
689: SELECT
690: t1.INVENTORY_ITEM_ID,

Line 724: MSC_DESIGNATORS md,

720: FROM
721: -- msc_tp_id_lid c1,
722: MSC_ITEM_ID_LID t1,
723: MSC_ITEM_ID_LID t2,
724: MSC_DESIGNATORS md,
725: MSC_ST_DEMANDS msd
726: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
727: AND t1.sr_instance_id= msd.sr_instance_id
728: AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id)

Line 833: ||' MSC_DESIGNATORS md, '

829: ||' :v_current_user '
830: ||' FROM '
831: ||' MSC_ITEM_ID_LID t1, '
832: ||' MSC_ITEM_ID_LID t2, '
833: ||' MSC_DESIGNATORS md, '
834: ||' MSC_ST_DEMANDS msd '
835: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '
836: ||' AND t1.sr_instance_id= msd.sr_instance_id '
837: ||' AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id) '

Line 1192: UPDATE MSC_DESIGNATORS

1188:
1189:
1190: FOR c_rec in c1_d loop
1191:
1192: UPDATE MSC_DESIGNATORS
1193: SET DISABLE_DATE= TRUNC(MSC_CL_COLLECTION.v_current_date),
1194: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1195: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1196: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 1222: from msc_designators

1218:
1219: Begin
1220: Select distinct designator_id
1221: into v_forecast_set_id
1222: from msc_designators
1223: where designator = c_rec.forecast_Set
1224: and organization_id = c_rec.organization_id
1225: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1226: Exception

Line 1229: Select MSC_DESIGNATORS_S.Nextval

1225: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1226: Exception
1227: when no_data_found
1228: then
1229: Select MSC_DESIGNATORS_S.Nextval
1230: into v_forecast_set_id
1231: from dual;
1232: End;
1233: Elsif c_rec.forecast_set is null then

Line 1239: UPDATE MSC_DESIGNATORS

1235: v_forecast_set_id := null;
1236: End if;
1237:
1238:
1239: UPDATE MSC_DESIGNATORS
1240: SET
1241: SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id,
1242: forecast_set_id = v_forecast_set_id,
1243: MPS_RELIEF= c_rec.MPS_RELIEF,

Line 1271: INSERT INTO MSC_DESIGNATORS

1267: IF SQL%NOTFOUND THEN
1268:
1269:
1270:
1271: INSERT INTO MSC_DESIGNATORS
1272: ( DESIGNATOR_ID,
1273: FORECAST_SET_ID,
1274: DESIGNATOR,
1275: DESIGNATOR_TYPE,

Line 1300: ( MSC_DESIGNATORS_S.NEXTVAL,

1296: LAST_UPDATED_BY,
1297: CREATION_DATE,
1298: CREATED_BY)
1299: VALUES
1300: ( MSC_DESIGNATORS_S.NEXTVAL,
1301: v_forecast_Set_id,
1302: c_rec.DESIGNATOR,
1303: 6,
1304: c_rec.ORGANIZATION_ID,

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

1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:
1350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1351: RAISE;

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

1355: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

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

1372:
1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 1446: UPDATE MSC_DESIGNATORS

1442:
1443: FOR c_rec IN c_del LOOP
1444: BEGIN
1445:
1446: UPDATE MSC_DESIGNATORS
1447: SET DISABLE_DATE= TRUNC(MSC_CL_COLLECTION.v_current_date),
1448: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1449: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1450: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 1473: UPDATE MSC_DESIGNATORS

1469:
1470: For c_rec in c1 LOOP
1471: BEGIN
1472:
1473: UPDATE MSC_DESIGNATORS
1474: SET SRC_SIM_FCST_ID =c_rec.SRC_SIM_FCST_ID,
1475: SRC_DESCRIPTION = c_rec.SRC_DESCRIPTION,
1476: SRC_DESIGNATOR = c_rec.SRC_DESIGNATOR,
1477: DESIGNATOR = c_rec.DESIGNATOR,

Line 1494: INSERT INTO MSC_DESIGNATORS

1490: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1491:
1492:
1493: IF SQL%NOTFOUND THEN
1494: INSERT INTO MSC_DESIGNATORS
1495: ( DESIGNATOR_ID,
1496: SRC_SIM_FCST_ID,
1497: DESIGNATOR,
1498: SRC_DESIGNATOR,

Line 1513: ( MSC_DESIGNATORS_S.NEXTVAL,

1509: LAST_UPDATED_BY,
1510: CREATION_DATE,
1511: CREATED_BY)
1512: VALUES
1513: ( MSC_DESIGNATORS_S.NEXTVAL,
1514: c_rec.SRC_SIM_FCST_ID,
1515: c_rec.DESIGNATOR,
1516: c_rec.SRC_DESIGNATOR,
1517: c_rec.SRC_DESCRIPTION,

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

1546:
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:
1553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1554: RAISE;

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

1558: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

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

1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 1665: MSC_DESIGNATORS md,

1661: FROM
1662: msc_tp_id_lid c1,
1663: MSC_ITEM_ID_LID t1,
1664: MSC_ITEM_ID_LID t2,
1665: MSC_DESIGNATORS md,
1666: MSC_TP_SITE_ID_LID mtsil,
1667: MSC_ST_DEMANDS msd
1668: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
1669: AND t1.sr_instance_id= msd.sr_instance_id

Line 3428: /*UPDATE MSC_DESIGNATORS

3424:
3425:
3426: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3427:
3428: /*UPDATE MSC_DESIGNATORS
3429: SET DISABLE_DATE= MSC_CL_COLLECTION.v_current_date,
3430: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
3431: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3432: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 3438: lv_sql_stmt:= 'UPDATE MSC_DESIGNATORS '

3434: AND designator_type <> 6 -- Added This condition for Bug# 2022521
3435: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES; */
3436:
3437:
3438: lv_sql_stmt:= 'UPDATE MSC_DESIGNATORS '
3439: ||' SET DISABLE_DATE = :v_current_date, '
3440: ||' REFRESH_NUMBER = :v_last_collection_id, '
3441: ||' LAST_UPDATE_DATE= :v_current_date, '
3442: ||' LAST_UPDATED_BY = :v_current_user '

Line 3480: UPDATE MSC_DESIGNATORS

3476: FOR c_rec IN c1 LOOP
3477:
3478: BEGIN
3479:
3480: UPDATE MSC_DESIGNATORS
3481: SET
3482: SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id,
3483: MPS_RELIEF= c_rec.MPS_RELIEF,
3484: INVENTORY_ATP_FLAG= c_rec.INVENTORY_ATP_FLAG,

Line 3502: INSERT INTO MSC_DESIGNATORS

3498: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
3499:
3500: IF SQL%NOTFOUND THEN
3501:
3502: INSERT INTO MSC_DESIGNATORS
3503: ( DESIGNATOR_ID,
3504: DESIGNATOR,
3505: ORGANIZATION_ID,
3506: MPS_RELIEF,

Line 3523: ( MSC_DESIGNATORS_S.NEXTVAL,

3519: LAST_UPDATED_BY,
3520: CREATION_DATE,
3521: CREATED_BY)
3522: VALUES
3523: ( MSC_DESIGNATORS_S.NEXTVAL,
3524: c_rec.DESIGNATOR,
3525: c_rec.ORGANIZATION_ID,
3526: c_rec.MPS_RELIEF,
3527: c_rec.INVENTORY_ATP_FLAG,

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

3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:
3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3564: RAISE;

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

3568:
3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');