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 256: AHL_SEARCH_WORKORDERS_V A

252: A.JOB_STATUS_CODE,
253: A.JOB_STATUS_MEANING,
254: A.WIP_ENTITY_ID
255: FROM
256: AHL_SEARCH_WORKORDERS_V A
257: --AHL_VISITS_B V,
258: --AHL_VISIT_TASKS_B VT,
259: --INV_ORGANIZATION_NAME_V ORG,
260: --FND_LOOKUP_VALUES WO_STS

Line 283: FROM AHL_SEARCH_WORKORDERS_V A

279: A.Organization_name,
280: A.JOB_STATUS_CODE,
281: A.job_status_meaning,
282: A.wip_entity_id
283: FROM AHL_SEARCH_WORKORDERS_V A
284: WHERE A.workorder_id=C_WORKORDER_ID;
285:
286: L_WORKDET_REC WORKORDER_CUR%ROWTYPE;
287: L_WORKDET_ID_REC WORKORDER_ID_CUR%ROWTYPE;

Line 6594: AHL_SEARCH_WORKORDERS_v W,

6590: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
6591: FROM
6592: CSI_ITEM_INSTANCES CSI,
6593: MTL_SYSTEM_ITEMS_KFV I,
6594: AHL_SEARCH_WORKORDERS_v W,
6595: WIP_PARAMETERS P,
6596: MTL_UNITS_OF_MEASURE_VL UOM,
6597: MTL_ITEM_LOCATIONS D,
6598: MTL_PARAMETERS MP