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.AHL_PRD_MTLTXN_PVT dependencies on AHL_SEARCH_WORKORDERS_V

Line 245: AHL_SEARCH_WORKORDERS_V A

241: A.JOB_STATUS_CODE,
242: A.JOB_STATUS_MEANING,
243: A.WIP_ENTITY_ID
244: FROM
245: AHL_SEARCH_WORKORDERS_V A
246: --AHL_VISITS_B V,
247: --AHL_VISIT_TASKS_B VT,
248: --INV_ORGANIZATION_NAME_V ORG,
249: --FND_LOOKUP_VALUES WO_STS

Line 272: FROM AHL_SEARCH_WORKORDERS_V A

268: A.Organization_name,
269: A.JOB_STATUS_CODE,
270: A.job_status_meaning,
271: A.wip_entity_id
272: FROM AHL_SEARCH_WORKORDERS_V A
273: WHERE A.workorder_id=C_WORKORDER_ID;
274:
275: L_WORKDET_REC WORKORDER_CUR%ROWTYPE;
276: L_WORKDET_ID_REC WORKORDER_ID_CUR%ROWTYPE;

Line 5083: AHL_SEARCH_WORKORDERS_v W,

5079: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5080: FROM
5081: CSI_ITEM_INSTANCES CSI,
5082: MTL_SYSTEM_ITEMS_KFV I,
5083: AHL_SEARCH_WORKORDERS_v W,
5084: WIP_PARAMETERS P,
5085: MTL_UNITS_OF_MEASURE_VL UOM,
5086: MTL_ITEM_LOCATIONS D,
5087: MTL_PARAMETERS MP