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_RPO_ODS_LOAD dependencies on MSC_DEMANDS

Line 87: lv_tbl:= 'MSC_DEMANDS';

83: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
84: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
85: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
86: ELSE
87: lv_tbl:= 'MSC_DEMANDS';
88: lv_supplies_tbl:= 'MSC_SUPPLIES';
89: END IF;
90:
91: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN

Line 113: defined as varchar(62) in msc_demands table */

109: -- for determining which SUPPLY table to be used for pegging.
110:
111: /** PREPLACE CHANGE END **/
112: /* 2201791 - select substr(order_number,1,62) since order_number is
113: defined as varchar(62) in msc_demands table */
114:
115: lv_del_stmt :=
116: 'Select mshr.repair_line_id,
117: T1.Inventory_item_id ,

Line 161: ||' -1, MSC_DEMANDS_S.nextval, '

157: end if ;
158:
159: lv_cursor_stmt:=
160: 'SELECT'
161: ||' -1, MSC_DEMANDS_S.nextval, '
162: ||' NVL(ms.TRANSACTION_ID,-1) DISPOSITION_ID,'
163: ||' t1.INVENTORY_ITEM_ID,'
164: ||' msd.ORGANIZATION_ID,'
165: ||' t2.INVENTORY_ITEM_ID USING_ASSEMBLY_ITEM_ID,'

Line 284: Delete from msc_demands

280:
281:
282: EXIT WHEN C10_d%NOTFOUND;
283:
284: Delete from msc_demands
285: WHERE PLAN_ID= -1
286: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
287: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE
288: AND REPAIR_LINE_ID= lv_REPAIR_LINE_ID

Line 318: Delete from msc_demands

314:
315:
316: EXIT WHEN C11_d%NOTFOUND;
317: if MSC_CL_COLLECTION.v_is_legacy_refresh then
318: Delete from msc_demands
319: WHERE PLAN_ID= -1
320: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
321: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE
322: AND REPAIR_LINE_ID= lv_REPAIR_LINE_ID

Line 328: Delete from msc_demands

324: AND ORGANIZATION_ID = lv_ORGANIZATION_ID
325: AND INVENTORY_ITEM_ID= NVL(lv_INVENTORY_ITEM_ID,INVENTORY_ITEM_ID)
326: AND WIP_ENTITY_NAME = lv_WIP_ENTITY_NAME ;
327: else
328: Delete from msc_demands
329: WHERE PLAN_ID= -1
330: AND SR_INSTANCE_ID= lv_SR_INSTANCE_ID
331: AND ORIGINATION_TYPE= lv_ORIGINATION_TYPE
332: AND REPAIR_LINE_ID= lv_REPAIR_LINE_ID

Line 405: Update MSC_DEMANDS

401: EXIT WHEN c2%NOTFOUND;
402:
403: BEGIN
404: if MSC_CL_COLLECTION.v_is_legacy_refresh then
405: Update MSC_DEMANDS
406: Set
407: USING_ASSEMBLY_ITEM_ID = lv_USING_ASSEMBLY_ITEM_ID ,
408: USING_ASSEMBLY_DEMAND_DATE = lv_USING_ASSEMBLY_DEMAND_DATE ,
409: USING_REQUIREMENT_QUANTITY = lv_USING_REQUIREMENT_QUANTITY ,

Line 437: Update MSC_DEMANDS

433: AND ORGANIZATION_ID = lv_ORGANIZATION_ID
434: AND INVENTORY_ITEM_ID= lv_INVENTORY_ITEM_ID
435: AND WIP_ENTITY_NAME = lv_WIP_ENTITY_NAME ;
436: ELSE
437: Update MSC_DEMANDS
438: Set
439: USING_ASSEMBLY_ITEM_ID = lv_USING_ASSEMBLY_ITEM_ID ,
440: USING_ASSEMBLY_DEMAND_DATE = lv_USING_ASSEMBLY_DEMAND_DATE ,
441: USING_REQUIREMENT_QUANTITY = lv_USING_REQUIREMENT_QUANTITY ,

Line 516: ||' MSC_DEMANDS_S.nextval,'

512: ||' CREATION_DATE,'
513: ||' CREATED_BY)'
514: ||'VALUES'
515: ||'( -1,'
516: ||' MSC_DEMANDS_S.nextval,'
517: ||' :INVENTORY_ITEM_ID,'
518: ||' :ORGANIZATION_ID,'
519: ||' :USING_ASSEMBLY_ITEM_ID,'
520: ||' :USING_ASSEMBLY_DEMAND_DATE,'

Line 606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

602: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
609: RAISE;
610: END;

Line 751: UPDATE MSC_DEMANDS

747: lv_ORGANIZATION_ID;
748:
749: EXIT WHEN c2_d%NOTFOUND;
750:
751: UPDATE MSC_DEMANDS
752: SET USING_REQUIREMENT_QUANTITY= 0,
753: DAILY_DEMAND_RATE= 0,
754: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
755: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 776: lv_tbl:= 'MSC_DEMANDS';

772: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
773: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
774: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
775: ELSE
776: lv_tbl:= 'MSC_DEMANDS';
777: lv_supplies_tbl:= 'MSC_SUPPLIES';
778: END IF;
779:
780:

Line 796: ||' -1, MSC_DEMANDS_S.nextval, '

792:
793:
794: lv_cursor_stmt:=
795: 'SELECT'
796: ||' -1, MSC_DEMANDS_S.nextval, '
797: ||' NVL(ms.TRANSACTION_ID,-1) DISPOSITION_ID,'
798: ||' t1.INVENTORY_ITEM_ID,'
799: ||' msd.ORGANIZATION_ID,'
800: ||' t2.INVENTORY_ITEM_ID USING_ASSEMBLY_ITEM_ID,'

Line 971: ||' MSC_DEMANDS_S.nextval,'

967: ||' CREATION_DATE,'
968: ||' CREATED_BY)'
969: ||'VALUES'
970: ||'( -1,'
971: ||' MSC_DEMANDS_S.nextval,'
972: ||' :INVENTORY_ITEM_ID,'
973: ||' :ORGANIZATION_ID,'
974: ||' :USING_ASSEMBLY_ITEM_ID,'
975: ||' :USING_ASSEMBLY_DEMAND_DATE,'

Line 1109: UPDATE MSC_DEMANDS

1105:
1106:
1107: IF lv_ORIGINATION_TYPE=77 THEN
1108:
1109: UPDATE MSC_DEMANDS
1110: SET
1111: OLD_USING_REQUIREMENT_QUANTITY= USING_REQUIREMENT_QUANTITY,
1112: OLD_USING_ASSEMBLY_DEMAND_DATE= USING_ASSEMBLY_DEMAND_DATE,
1113: OLD_ASSEMBLY_DEMAND_COMP_DATE= ASSEMBLY_DEMAND_COMP_DATE,

Line 1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1195:
1196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;