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_BOM_ODS_LOAD dependencies on MSC_PROCESS_EFFECTIVITY

Line 1249: FROM MSC_PROCESS_EFFECTIVITY mpe,

1245: mpe.ROUTING_SEQUENCE_ID,
1246: mpe.BILL_SEQUENCE_ID,
1247: TO_NUMBER(NULL),
1248: mpe.SR_INSTANCE_ID
1249: FROM MSC_PROCESS_EFFECTIVITY mpe,
1250: MSC_ST_PROCESS_EFFECTIVITY mspe
1251: WHERE mspe.Bill_Sequence_ID= mpe.Bill_Sequence_ID
1252: AND mspe.Routing_Sequence_ID <> mpe.Routing_Sequence_ID
1253: AND mspe.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1295: DELETE MSC_PROCESS_EFFECTIVITY

1291:
1292: -- deleting if the record already existed.
1293: FOR c_rec IN c_del_leg LOOP
1294:
1295: DELETE MSC_PROCESS_EFFECTIVITY
1296: WHERE PLAN_ID= -1
1297: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1298: AND ( ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
1299: OR BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID )

Line 1312: lv_sql_stmt1 := ' DELETE MSC_PROCESS_EFFECTIVITY '

1308: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1309:
1310: FOR c_rec IN c8_d LOOP
1311: ---5470477
1312: lv_sql_stmt1 := ' DELETE MSC_PROCESS_EFFECTIVITY '
1313: ||' WHERE PLAN_ID= -1 '
1314: ||' AND SR_INSTANCE_ID= :SR_INSTANCE_ID ';
1315:
1316: BEGIN --- To use bind variables as far as possible

Line 1374: DELETE MSC_PROCESS_EFFECTIVITY

1370: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LINE_ID: ' || c_rec.LINE_ID);
1371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '-----------------------------');
1372: END;
1373: /*
1374: DELETE MSC_PROCESS_EFFECTIVITY
1375: WHERE PLAN_ID= -1
1376: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
1377: AND ( ( ITEM_ID= c_rec.INVENTORY_ITEM_ID
1378: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID

Line 1397: UPDATE MSC_PROCESS_EFFECTIVITY

1393: BEGIN
1394:
1395: /* bug 1244578 fix */
1396:
1397: UPDATE MSC_PROCESS_EFFECTIVITY
1398: SET
1399: MINIMUM_QUANTITY= c_rec.MINIMUM_QUANTITY,
1400: MAXIMUM_QUANTITY= c_rec.MAXIMUM_QUANTITY,
1401: PREFERENCE= c_rec.PREFERENCE,

Line 1429: INSERT INTO MSC_PROCESS_EFFECTIVITY

1425: AND c_rec.LINE_ID IS NULL));
1426:
1427: IF SQL%NOTFOUND THEN
1428:
1429: INSERT INTO MSC_PROCESS_EFFECTIVITY
1430: ( PLAN_ID,
1431: PROCESS_SEQUENCE_ID,
1432: ITEM_ID,
1433: ORGANIZATION_ID,

Line 1456: MSC_PROCESS_EFFECTIVITY_S.NEXTVAL,

1452: CREATION_DATE,
1453: CREATED_BY)
1454: VALUES
1455: ( -1,
1456: MSC_PROCESS_EFFECTIVITY_S.NEXTVAL,
1457: c_rec.INVENTORY_ITEM_ID,
1458: c_rec.ORGANIZATION_ID,
1459: c_rec.EFFECTIVITY_DATE,
1460: c_rec.DISABLE_DATE,

Line 1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');

1493:
1494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1495: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1499:
1500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1501: RAISE;

Line 1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');

1505:
1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1507: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 1545: /* DELETE MSC_PROCESS_EFFECTIVITY

1541: /* if it's complete refresh, delete the old records after the insert/update */
1542: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1543: -- We want to delete all BOM related data and get new stuff.
1544:
1545: /* DELETE MSC_PROCESS_EFFECTIVITY
1546: WHERE PLAN_ID= -1
1547: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1548: AND REFRESH_NUMBER <> MSC_CL_COLLECTION.v_last_collection_id; */
1549:

Line 1552: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1548: AND REFRESH_NUMBER <> MSC_CL_COLLECTION.v_last_collection_id; */
1549:
1550: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1551: v_sub_str :='AND REFRESH_NUMBER <>'||MSC_CL_COLLECTION.v_last_collection_id;
1552: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1553: ELSE
1554: v_sub_str :=' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1555: ||' AND REFRESH_NUMBER <>'||MSC_CL_COLLECTION.v_last_collection_id;
1556: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 1556: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1552: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1553: ELSE
1554: v_sub_str :=' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1555: ||' AND REFRESH_NUMBER <>'||MSC_CL_COLLECTION.v_last_collection_id;
1556: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1557: END IF;
1558:
1559:
1560: