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_AHL_ODS_LOAD dependencies on MSC_SUPPLIES

Line 311: lv_supplies_tbl:= 'MSC_SUPPLIES';

307: lv_tbl:= 'WO_ATTRIBUTES_'||MSC_CL_COLLECTION.v_instance_code;
308: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
309: ELSE
310: lv_tbl:= 'MSC_WO_ATTRIBUTES';
311: lv_supplies_tbl:= 'MSC_SUPPLIES';
312: END IF;
313:
314: lv_cursor_stmt:=
315: 'INSERT INTO '||lv_tbl

Line 837: lv_supplies_tbl:= 'MSC_SUPPLIES';

833: lv_tbl:= 'WO_TASK_HIERARCHY_'||MSC_CL_COLLECTION.v_instance_code;
834: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
835: ELSE
836: lv_tbl:= 'MSC_WO_TASK_HIERARCHY';
837: lv_supplies_tbl:= 'MSC_SUPPLIES';
838: END IF;
839:
840: lv_cursor_stmt:=
841: 'INSERT INTO '||lv_tbl

Line 1124: lv_supplies_tbl:= 'MSC_SUPPLIES';

1120: lv_tbl:= 'WO_OPERATION_REL_'||MSC_CL_COLLECTION.v_instance_code;
1121: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1122: ELSE
1123: lv_tbl:= 'MSC_WO_OPERATION_REL';
1124: lv_supplies_tbl:= 'MSC_SUPPLIES';
1125: END IF;
1126:
1127: lv_cursor_stmt:=
1128: 'INSERT INTO '||lv_tbl

Line 1618: lv_supplies_tbl:= 'MSC_SUPPLIES';

1614: lv_tbl:= 'WO_SUB_COMP_'||MSC_CL_COLLECTION.v_instance_code;
1615: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1616: ELSE
1617: lv_tbl:= 'MSC_WO_SUB_COMP';
1618: lv_supplies_tbl:= 'MSC_SUPPLIES';
1619: END IF;
1620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1621: 'In Procedure LOAD_WO_SUB_COMP, lv_tbl: '||lv_tbl);
1622:

Line 1721: lv_supplies_tbl:= 'MSC_SUPPLIES';

1717:
1718: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1719: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1720: ELSE
1721: lv_supplies_tbl:= 'MSC_SUPPLIES';
1722: END IF;
1723:
1724: lv_cursor_stmt:=
1725: 'SELECT '

Line 1727: ||' MSC_SUPPLIES_S.NEXTVAL,'

1723:
1724: lv_cursor_stmt:=
1725: 'SELECT '
1726: ||' -1,'
1727: ||' MSC_SUPPLIES_S.NEXTVAL,'
1728: ||' md.DESIGNATOR_ID,'
1729: ||' ms.ORGANIZATION_ID,'
1730: ||' ms.NEW_WIP_START_DATE,'
1731: ||' ms.NEW_SCHEDULE_DATE,'

Line 1732: ||' ''AGGR-'''||'||MSC_SUPPLIES_AGGR_WO_S.NEXTVAL,'-- CHECK FOR SEQ AND CHANGE THIS mnagilla

1728: ||' md.DESIGNATOR_ID,'
1729: ||' ms.ORGANIZATION_ID,'
1730: ||' ms.NEW_WIP_START_DATE,'
1731: ||' ms.NEW_SCHEDULE_DATE,'
1732: ||' ''AGGR-'''||'||MSC_SUPPLIES_AGGR_WO_S.NEXTVAL,'-- CHECK FOR SEQ AND CHANGE THIS mnagilla
1733: ||' t1.INVENTORY_ITEM_ID,' -- mnagilla check for translation
1734: ||' ms.ORDER_TYPE,'
1735: ||' ms.COLL_ORDER_TYPE,'
1736: ||' ms.MAINTENANCE_OBJECT_SOURCE,'

Line 1848: lv_supplies_tbl:= 'MSC_SUPPLIES';

1844: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1845: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1846: ELSE
1847: lv_tbl:= 'MSC_DEMANDS';
1848: lv_supplies_tbl:= 'MSC_SUPPLIES';
1849: END IF;
1850:
1851:
1852: lv_cursor_stmt:=

Line 1973: lv_supplies_tbl:= 'MSC_SUPPLIES';

1969: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
1970: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1971: ELSE
1972: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';
1973: lv_supplies_tbl:= 'MSC_SUPPLIES';
1974: END IF;
1975:
1976:
1977: lv_cursor_stmt:=

Line 2341: lv_tbl:= 'MSC_SUPPLIES';

2337: 'In Procedure LOAD_CLOSED_CMRO_WOS ');
2338: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2339: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2340: ELSE
2341: lv_tbl:= 'MSC_SUPPLIES';
2342: END IF;
2343:
2344: BEGIN
2345: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

Line 2348: lv_tbl:= 'MSC_SUPPLIES';

2344: BEGIN
2345: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
2346: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2347: ELSE
2348: lv_tbl:= 'MSC_SUPPLIES';
2349: END IF;
2350:
2351: lv_cursor_stmt:= ' SELECT '
2352: ||' -1, MSC_SUPPLIES_S.NEXTVAL,'

Line 2352: ||' -1, MSC_SUPPLIES_S.NEXTVAL,'

2348: lv_tbl:= 'MSC_SUPPLIES';
2349: END IF;
2350:
2351: lv_cursor_stmt:= ' SELECT '
2352: ||' -1, MSC_SUPPLIES_S.NEXTVAL,'
2353: ||' t1.INVENTORY_ITEM_ID,'
2354: ||' t1.INVENTORY_ITEM_ID,'
2355: ||' ms.visit_id,'
2356: ||' ms.ORGANIZATION_ID,'

Line 2462: DELETE MSC_SUPPLIES

2458: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR
2459: MSC_CL_COLLECTION.v_is_legacy_refresh THEN
2460: FOR c_rec IN c_del LOOP
2461: BEGIN
2462: DELETE MSC_SUPPLIES
2463: WHERE PLAN_ID= -1
2464: AND SR_INSTANCE_ID= c_rec.sr_instance_id
2465: AND DISPOSITION_ID= c_rec.DISPOSITION_ID
2466: AND ORDER_TYPE= c_rec.ORDER_TYPE

Line 2480: UPDATE MSC_SUPPLIES

2476: COMMIT;
2477:
2478: FOR c_rec in c1
2479: LOOP
2480: UPDATE MSC_SUPPLIES
2481: SET
2482: NEW_ORDER_QUANTITY = c_rec.NEW_ORDER_QUANTITY,
2483: NEW_SCHEDULE_DATE = c_rec.NEW_SCHEDULE_DATE,
2484: EXPECTED_SCRAP_QTY = c_rec.EXPECTED_SCRAP_QTY,

Line 2556: ||' values ( -1,MSC_SUPPLIES_S.NEXTVAL,'

2552: ||' LAST_UPDATE_DATE, '
2553: ||' LAST_UPDATED_BY, '
2554: ||' CREATION_DATE, '
2555: ||' CREATED_BY) '
2556: ||' values ( -1,MSC_SUPPLIES_S.NEXTVAL,'
2557: ||' :v_INVENTORY_ITEM_ID,'
2558: ||' :v_asset_item_id,'
2559: ||' :v_visit_id,'
2560: ||' :v_ORGANIZATION_ID,'

Line 2672: lv_supplies_tbl:= 'MSC_SUPPLIES';

2668:
2669: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
2670: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2671: ELSE
2672: lv_supplies_tbl:= 'MSC_SUPPLIES';
2673: END IF;
2674:
2675: lv_cursor_stmt:=
2676: 'SELECT'

Line 2678: ||' MSC_SUPPLIES_S.NEXTVAL,'

2674:
2675: lv_cursor_stmt:=
2676: 'SELECT'
2677: ||' -1,'
2678: ||' MSC_SUPPLIES_S.NEXTVAL,'
2679: ||' ms.ORGANIZATION_ID,'
2680: --||' ms.NEW_WIP_START_DATE,'
2681: ||' ms.NEW_SCHEDULE_DATE,'
2682: ||' ms.NEW_ORDER_QUANTITY,'