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 86: lv_tbl:= 'MSC_DEMANDS';

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

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

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

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

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

Line 287: Delete from msc_demands

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

Line 321: Delete from msc_demands

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

Line 331: Delete from msc_demands

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

Line 408: Update MSC_DEMANDS

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

Line 441: Update MSC_DEMANDS

437: AND INVENTORY_ITEM_ID= lv_INVENTORY_ITEM_ID
438: AND WIP_ENTITY_NAME = lv_WIP_ENTITY_NAME
439: AND ITEM_TYPE_VALUE = lv_ITEM_TYPE_VALUE;
440: ELSE
441: Update MSC_DEMANDS
442: Set
443: USING_ASSEMBLY_ITEM_ID = lv_USING_ASSEMBLY_ITEM_ID ,
444: USING_ASSEMBLY_DEMAND_DATE = lv_USING_ASSEMBLY_DEMAND_DATE ,
445: USING_REQUIREMENT_QUANTITY = lv_USING_REQUIREMENT_QUANTITY ,

Line 520: ||' MSC_DEMANDS_S.nextval,'

516: ||' CREATION_DATE,'
517: ||' CREATED_BY)'
518: ||'VALUES'
519: ||'( -1,'
520: ||' MSC_DEMANDS_S.nextval,'
521: ||' :INVENTORY_ITEM_ID,'
522: ||' :ORGANIZATION_ID,'
523: ||' :USING_ASSEMBLY_ITEM_ID,'
524: ||' :USING_ASSEMBLY_DEMAND_DATE,'

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

606: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
607:
608: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
609: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
610: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
613: RAISE;
614: END;

Line 755: UPDATE MSC_DEMANDS

751: lv_ORGANIZATION_ID;
752:
753: EXIT WHEN c2_d%NOTFOUND;
754:
755: UPDATE MSC_DEMANDS
756: SET USING_REQUIREMENT_QUANTITY= 0,
757: DAILY_DEMAND_RATE= 0,
758: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
759: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 780: lv_tbl:= 'MSC_DEMANDS';

776: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
777: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
778: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
779: ELSE
780: lv_tbl:= 'MSC_DEMANDS';
781: lv_supplies_tbl:= 'MSC_SUPPLIES';
782: END IF;
783:
784:

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

796:
797:
798: lv_cursor_stmt:=
799: 'SELECT'
800: ||' -1, MSC_DEMANDS_S.nextval, '
801: ||' NVL(ms.TRANSACTION_ID,-1) DISPOSITION_ID,'
802: ||' t1.INVENTORY_ITEM_ID,'
803: ||' msd.ORGANIZATION_ID,'
804: ||' t2.INVENTORY_ITEM_ID USING_ASSEMBLY_ITEM_ID,'

Line 975: ||' MSC_DEMANDS_S.nextval,'

971: ||' CREATION_DATE,'
972: ||' CREATED_BY)'
973: ||'VALUES'
974: ||'( -1,'
975: ||' MSC_DEMANDS_S.nextval,'
976: ||' :INVENTORY_ITEM_ID,'
977: ||' :ORGANIZATION_ID,'
978: ||' :USING_ASSEMBLY_ITEM_ID,'
979: ||' :USING_ASSEMBLY_DEMAND_DATE,'

Line 1113: UPDATE MSC_DEMANDS

1109:
1110:
1111: IF lv_ORIGINATION_TYPE=77 THEN
1112:
1113: UPDATE MSC_DEMANDS
1114: SET
1115: OLD_USING_REQUIREMENT_QUANTITY= USING_REQUIREMENT_QUANTITY,
1116: OLD_USING_ASSEMBLY_DEMAND_DATE= USING_ASSEMBLY_DEMAND_DATE,
1117: OLD_ASSEMBLY_DEMAND_COMP_DATE= ASSEMBLY_DEMAND_COMP_DATE,

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

1199:
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1201: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1202: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1203: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1205:
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1207: RAISE;