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_WIP_ODS_LOAD dependencies on MSC_RESOURCE_REQUIREMENTS

Line 3365: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';

3361: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3362: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
3363: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
3364: ELSE
3365: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';
3366: lv_supplies_tbl:= 'MSC_SUPPLIES';
3367: END IF;
3368:
3369: /** PREPLACE CHANGE START **/

Line 3501: ||' MSC_RESOURCE_REQUIREMENTS_S.NEXTVAL,'

3497: ||' CREATION_DATE,'
3498: ||' CREATED_BY)'
3499: ||'VALUES'
3500: ||'( -1,'
3501: ||' MSC_RESOURCE_REQUIREMENTS_S.NEXTVAL,'
3502: ||' :DEPARTMENT_ID,'
3503: ||' :RESOURCE_ID,'
3504: ||' :ORGANIZATION_ID,'
3505: ||' :ASSEMBLY_ITEM_ID,'

Line 3619: ||' MSC_RESOURCE_REQUIREMENTS_S.NEXTVAL,'

3615: ||' CREATION_DATE,'
3616: ||' CREATED_BY)'
3617: ||' SELECT'
3618: ||' -1,'
3619: ||' MSC_RESOURCE_REQUIREMENTS_S.NEXTVAL,'
3620: ||' msrr.DEPARTMENT_ID,'
3621: ||' msrr.RESOURCE_ID,'
3622: ||' msrr.ORGANIZATION_ID,'
3623: ||' miil.INVENTORY_ITEM_ID,'

Line 3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

3695:
3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:
3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3703: RAISE;

Line 3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

3705: ELSE
3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:
3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3713:

Line 3730: UPDATE MSC_RESOURCE_REQUIREMENTS

3726:
3727: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
3728:
3729: FOR c_rec IN c4_d LOOP
3730: UPDATE MSC_RESOURCE_REQUIREMENTS
3731: SET RESOURCE_HOURS= 0,
3732: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
3733: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3734: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 3811: UPDATE MSC_RESOURCE_REQUIREMENTS

3807: END IF;
3808:
3809: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
3810:
3811: UPDATE MSC_RESOURCE_REQUIREMENTS
3812: SET
3813: DEPARTMENT_ID= lv_DEPARTMENT_ID,
3814: RESOURCE_ID= lv_RESOURCE_ID,
3815: ASSEMBLY_ITEM_ID = lv_ASSEMBLY_ITEM_ID,

Line 3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

3941:
3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:
3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3949: RAISE;

Line 3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

3954:
3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 3999: ||' SELECT * from MSC_RESOURCE_REQUIREMENTS'

3995: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
3996:
3997: lv_sql_stmt:=
3998: 'INSERT INTO '||lv_tbl
3999: ||' SELECT * from MSC_RESOURCE_REQUIREMENTS'
4000: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4001: ||' AND plan_id = -1 '
4002: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4003:

Line 4023: 'MSC_RESOURCE_REQUIREMENTS',

4019:
4020: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4021: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4022: lv_retcode,
4023: 'MSC_RESOURCE_REQUIREMENTS',
4024: MSC_CL_COLLECTION.v_instance_code,
4025: MSC_UTIL.G_WARNING
4026: );
4027: