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_ST_WO_ATTRIBUTES

Line 251: FROM MSC_ST_WO_ATTRIBUTES mswa

247: SELECT mswa.SUPPLY_ID,
248: mswa.VISIT_ID,
249: mswa.ORGANIZATION_ID,
250: mswa.SR_INSTANCE_ID
251: FROM MSC_ST_WO_ATTRIBUTES mswa
252: WHERE mswa.deleted_flag = MSC_UTIL.SYS_YES
253: AND mswa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
254:
255: lv_supplies_tbl VARCHAR2(30);

Line 259: SUPPLY_ID MSC_ST_WO_ATTRIBUTES.SUPPLY_ID%type,

255: lv_supplies_tbl VARCHAR2(30);
256: type ref_cur is ref cursor;
257: c_ref_cur ref_cur;
258: TYPE cursorRec IS RECORD (
259: SUPPLY_ID MSC_ST_WO_ATTRIBUTES.SUPPLY_ID%type,
260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,
261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,

Line 260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,

256: type ref_cur is ref cursor;
257: c_ref_cur ref_cur;
258: TYPE cursorRec IS RECORD (
259: SUPPLY_ID MSC_ST_WO_ATTRIBUTES.SUPPLY_ID%type,
260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,
261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,

Line 261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,

257: c_ref_cur ref_cur;
258: TYPE cursorRec IS RECORD (
259: SUPPLY_ID MSC_ST_WO_ATTRIBUTES.SUPPLY_ID%type,
260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,
261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,

Line 262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,

258: TYPE cursorRec IS RECORD (
259: SUPPLY_ID MSC_ST_WO_ATTRIBUTES.SUPPLY_ID%type,
260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,
261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,

Line 263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,

259: SUPPLY_ID MSC_ST_WO_ATTRIBUTES.SUPPLY_ID%type,
260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,
261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,

Line 264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,

260: PRODUCES_TO_STOCK MSC_ST_WO_ATTRIBUTES.PRODUCES_TO_STOCK%type,
261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,

Line 265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,

261: SERIAL_NUM MSC_ST_WO_ATTRIBUTES.SERIAL_NUM%type,
262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,

Line 266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,

262: VISIT_ID MSC_ST_WO_ATTRIBUTES.VISIT_ID%type,
263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,

Line 267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,

263: VISIT_NAME MSC_ST_WO_ATTRIBUTES.VISIT_NAME%type,
264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,

Line 268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,

264: PARAMETER1 MSC_ST_WO_ATTRIBUTES.PARAMETER1%type,
265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,

Line 269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,

265: PARAMETER2 MSC_ST_WO_ATTRIBUTES.PARAMETER2%type,
266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,

Line 270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,

266: PARAMETER3 MSC_ST_WO_ATTRIBUTES.PARAMETER3%type,
267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,

Line 271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,

267: PARAMETER4 MSC_ST_WO_ATTRIBUTES.PARAMETER4%type,
268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,

Line 272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,

268: PARAMETER5 MSC_ST_WO_ATTRIBUTES.PARAMETER5%type,
269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,

Line 273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,

269: PARAMETER6 MSC_ST_WO_ATTRIBUTES.PARAMETER6%type,
270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,

Line 274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,

270: PARAMETER7 MSC_ST_WO_ATTRIBUTES.PARAMETER7%type,
271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,

Line 275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,

271: PARAMETER8 MSC_ST_WO_ATTRIBUTES.PARAMETER8%type,
272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,
279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,

Line 276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,

272: PARAMETER9 MSC_ST_WO_ATTRIBUTES.PARAMETER9%type,
273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,
279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,
280: WIP_ENTITY_ID MSC_ST_WO_ATTRIBUTES.WIP_ENTITY_ID%type

Line 277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,

273: MASTER_WO MSC_ST_WO_ATTRIBUTES.MASTER_WO%type,
274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,
279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,
280: WIP_ENTITY_ID MSC_ST_WO_ATTRIBUTES.WIP_ENTITY_ID%type
281: );

Line 278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,

274: PREV_MILESTONE MSC_ST_WO_ATTRIBUTES.PREV_MILESTONE%type,
275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,
279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,
280: WIP_ENTITY_ID MSC_ST_WO_ATTRIBUTES.WIP_ENTITY_ID%type
281: );
282:

Line 279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,

275: NEXT_MILESTONE MSC_ST_WO_ATTRIBUTES.NEXT_MILESTONE%type,
276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,
279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,
280: WIP_ENTITY_ID MSC_ST_WO_ATTRIBUTES.WIP_ENTITY_ID%type
281: );
282:
283: c_rec cursorRec;

Line 280: WIP_ENTITY_ID MSC_ST_WO_ATTRIBUTES.WIP_ENTITY_ID%type

276: ORGANIZATION_ID MSC_ST_WO_ATTRIBUTES.ORGANIZATION_ID%type,
277: ITEM_ALTERNATES_EXIST MSC_ST_WO_ATTRIBUTES.ITEM_ALTERNATES_EXIST%type,
278: PRODUCT_CLASSIFICATION MSC_ST_WO_ATTRIBUTES.PRODUCT_CLASSIFICATION%type,
279: MAINTENANCE_REQT MSC_ST_WO_ATTRIBUTES.MAINTENANCE_REQT%type,
280: WIP_ENTITY_ID MSC_ST_WO_ATTRIBUTES.WIP_ENTITY_ID%type
281: );
282:
283: c_rec cursorRec;
284: BEGIN

Line 376: ||' FROM MSC_ST_WO_ATTRIBUTES mswa, '

372: ||':v_current_date, '
373: ||':v_current_user, '
374: ||':v_current_date, '
375: ||':v_current_user '
376: ||' FROM MSC_ST_WO_ATTRIBUTES mswa, '
377: || lv_supplies_tbl||' ms'
378: ||' WHERE mswa.DELETED_FLAG = '||MSC_UTIL.SYS_NO
379: ||' AND mswa.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
380: ||' AND ms.SR_INSTANCE_ID(+)= mswa.SR_INSTANCE_ID'

Line 449: ||' FROM MSC_ST_WO_ATTRIBUTES mswa, '

445: ||'mswa.PRODUCT_CLASSIFICATION, '
446: -- ||'mswa.Operating_Fleet, '/* remove the above line and uncomment this line for bug fix# 12428753 */
447: ||'mswa.MAINTENANCE_REQT, '
448: ||'mswa.WIP_ENTITY_ID '
449: ||' FROM MSC_ST_WO_ATTRIBUTES mswa, '
450: || lv_supplies_tbl||' ms'
451: ||' WHERE mswa.DELETED_FLAG = '||MSC_UTIL.SYS_NO
452: ||' AND mswa.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
453: ||' AND ms.SR_INSTANCE_ID(+)= mswa.SR_INSTANCE_ID'