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_RESERVATIONS

Line 3112: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

3108:
3109: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3110: -- We want to delete all HARD_RESERV related data and get new stuff.
3111:
3112: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3113:
3114: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3115: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3116: ELSE

Line 3115: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

3111:
3112: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3113:
3114: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3115: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3116: ELSE
3117: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3118: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
3119: END IF;

Line 3118: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

3114: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3115: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3116: ELSE
3117: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3118: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
3119: END IF;
3120:
3121: END IF;
3122:

Line 3127: UPDATE MSC_RESERVATIONS

3123: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
3124:
3125: /* FOR c_rec IN c1_d LOOP
3126:
3127: UPDATE MSC_RESERVATIONS
3128: SET RESERVED_QUANTITY= 0,
3129: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
3130: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3131: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 3144: Delete from msc_reservations

3140:
3141: If c_rec.supply_source_type_id = 86 then
3142:
3143:
3144: Delete from msc_reservations
3145: Where
3146: ((reservation_type = 5 and organization_id = c_rec.organization_id) or reservation_type = 7)
3147: And sr_instance_id =c_rec.SR_INSTANCE_ID
3148: And plan_id =-1

Line 3153: Delete from msc_reservations

3149: And REPAIR_PO_HEADER_ID =c_rec.transaction_id ;
3150:
3151: Elsif c_rec.supply_source_type_id = 1 then
3152:
3153: Delete from msc_reservations
3154: Where sr_instance_id =c_rec.SR_INSTANCE_ID
3155: And plan_id =-1
3156: And ((disposition_id =c_rec.transaction_id and reservation_type = 5 and organization_id = c_rec.organization_id and disposition_type =1 )
3157: Or (transaction_id =c_rec.transaction_id and reservation_type = 7));

Line 3161: Delete from msc_reservations

3157: Or (transaction_id =c_rec.transaction_id and reservation_type = 7));
3158:
3159: Elsif c_rec.supply_source_type_id = 7 then
3160:
3161: Delete from msc_reservations
3162: Where sr_instance_id =c_rec.SR_INSTANCE_ID
3163: And plan_id =-1
3164: And transaction_id =c_rec.transaction_id
3165: And reservation_type = 4;

Line 3169: Delete from msc_reservations

3165: And reservation_type = 4;
3166:
3167: Elsif c_rec.supply_source_type_id = 200 then
3168:
3169: Delete from msc_reservations
3170: Where sr_instance_id =c_rec.SR_INSTANCE_ID
3171: And plan_id =-1
3172: And ((disposition_id =c_rec.transaction_id and reservation_type = 4 and disposition_type =200 and organization_id = c_rec.organization_id)
3173: Or (transaction_id =c_rec.transaction_id and reservation_type = 3));

Line 3179: Delete from msc_reservations

3175:
3176:
3177: Elsif c_rec.supply_source_type_id = 2 then
3178:
3179: Delete from msc_reservations
3180: Where sr_instance_id =c_rec.SR_INSTANCE_ID
3181: And plan_id =-1
3182: And disposition_id =c_rec.transaction_id
3183: And reservation_type in (7,3)

Line 3189: Delete from msc_reservations

3185: And organization_id = c_rec.organization_id ;
3186:
3187: Elsif c_rec.supply_source_type_id = 5 then
3188:
3189: Delete from msc_reservations
3190: Where sr_instance_id =c_rec.SR_INSTANCE_ID
3191: And plan_id =-1
3192: And transaction_id/2 = c_rec.transaction_id
3193: And reservation_type = 5 ;

Line 3199: UPDATE MSC_RESERVATIONS

3195: Else
3196:
3197: -- IF c_rec.supply_source_type_id IS NULL AND c_rec.reservation_type is NULL THEN
3198:
3199: UPDATE MSC_RESERVATIONS
3200: SET RESERVED_QUANTITY= 0,
3201: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
3202: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3203: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 3224: UPDATE MSC_RESERVATIONS

3220: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
3221:
3222:
3223:
3224: UPDATE MSC_RESERVATIONS
3225: SET
3226: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
3227: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
3228: DEMAND_CLASS= c_rec.DEMAND_CLASS,

Line 3257: insert into MSC_RESERVATIONS

3253: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
3254:
3255:
3256:
3257: insert into MSC_RESERVATIONS
3258: ( TRANSACTION_ID,
3259: INVENTORY_ITEM_ID,
3260: ORGANIZATION_ID,
3261: PLAN_ID,

Line 3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');

3323:
3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:
3330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3331: RAISE;

Line 3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');

3336: IF (print_all_debug_msg) THEN
3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');