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_ROUTING_ODS_LOAD dependencies on MSC_ROUTING_OPERATIONS

Line 1526: lv_tbl:= 'MSC_ROUTING_OPERATIONS';

1522:
1523: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1524: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1525: ELSE
1526: lv_tbl:= 'MSC_ROUTING_OPERATIONS';
1527: END IF;
1528:
1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1530: -- We want to delete all BOM related data and get new stuff

Line 1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

1527: END IF;
1528:
1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1539: END IF;

Line 1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1539: END IF;
1540: END IF;
1541:
1542: BEGIN

Line 1627: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1623:
1624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1625: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1626: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1627: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1629:
1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1631: RAISE;

Line 1637: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1633: ELSE
1634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1635: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1636: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1637: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1639:
1640: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1641:

Line 1728: DELETE MSC_ROUTING_OPERATIONS

1724:
1725: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1726: FOR c_rec IN c5_d LOOP
1727:
1728: DELETE MSC_ROUTING_OPERATIONS
1729: WHERE PLAN_ID= -1
1730: AND ROUTING_SEQUENCE_ID= NVL(c_rec.ROUTING_SEQUENCE_ID,ROUTING_SEQUENCE_ID)
1731: AND OPERATION_SEQUENCE_ID= NVL(c_rec.OPERATION_SEQUENCE_ID,OPERATION_SEQUENCE_ID)
1732: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line 1744: UPDATE MSC_ROUTING_OPERATIONS

1740:
1741: BEGIN
1742:
1743: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1744: UPDATE MSC_ROUTING_OPERATIONS
1745: SET
1746: OPERATION_SEQ_NUM= c_rec.OPERATION_SEQ_NUM,
1747: OPERATION_DESCRIPTION= c_rec.OPERATION_DESCRIPTION,
1748: EFFECTIVITY_DATE= c_rec.EFFECTIVITY_DATE,

Line 1830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1826:
1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1832:
1833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1834: RAISE;

Line 1842: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1842: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1844:
1845: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1846: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'

1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1874:
1875: lv_sql_stmt:=
1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'
1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1879: ||' AND plan_id = -1 '
1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1881:

Line 1892: 'MSC_ROUTING_OPERATIONS',

1888:
1889: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1891: lv_retcode,
1892: 'MSC_ROUTING_OPERATIONS',
1893: MSC_CL_COLLECTION.v_instance_code,
1894: MSC_UTIL.G_WARNING
1895: );
1896:

Line 2453: from MSC_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn

2449: IS
2450:
2451: cursor c1 IS
2452: select distinct mr.ROUTING_SEQUENCE_ID,trunc(mn.effectivity_date) effectivity_date
2453: from MSC_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn
2454: where
2455: mr.sr_instance_id=mn.sr_instance_id
2456: and mr.routing_sequence_id= mn.routing_sequence_id
2457: and mr.CFM_ROUTING_FLAG=3

Line 2504: from MSC_ST_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn

2500: IS
2501:
2502: cursor c1 IS
2503: select distinct mr.ROUTING_SEQUENCE_ID,trunc(mn.effectivity_date) effectivity_date
2504: from MSC_ST_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn
2505: where
2506: mr.sr_instance_id=mn.sr_instance_id
2507: and mr.routing_sequence_id= mn.routing_sequence_id
2508: and mr.CFM_ROUTING_FLAG=3

Line 2564: MSC_ROUTING_OPERATIONS mro

2560:
2561: SELECT unique mon.FROM_OP_SEQ_ID, trunc(mro.EFFECTIVITY_DATE), trunc(nvl(mro.DISABLE_DATE,sysdate + 2))
2562: INTO l_from_op_seqid, l_effdate, l_disabdate
2563: FROM MSC_OPERATION_NETWORKS mon,
2564: MSC_ROUTING_OPERATIONS mro
2565: WHERE mon.PLAN_ID= -1
2566: AND mon.SR_INSTANCE_ID = v_instance_id
2567: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2568: AND NOT EXISTS (SELECT 1 FROM MSC_OPERATION_NETWORKS mon2

Line 2613: MSC_ROUTING_OPERATIONS mro

2609:
2610: SELECT unique mon.TO_OP_SEQ_ID, trunc(mro.EFFECTIVITY_DATE), trunc(nvl(mro.DISABLE_DATE,sysdate + 2))
2611: INTO l_to_op_seqid, l_effdate, l_disabdate
2612: FROM MSC_OPERATION_NETWORKS mon,
2613: MSC_ROUTING_OPERATIONS mro
2614: WHERE mon.PLAN_ID= -1
2615: AND mon.SR_INSTANCE_ID = v_instance_id
2616: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2617: AND NOT EXISTS (SELECT 1 FROM MSC_OPERATION_NETWORKS mon2