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_WORKORDER_PVT dependencies on AHL_ALL_WORKORDERS_V

Line 194: FROM AHL_ALL_WORKORDERS_V

190:
191: CURSOR get_workorder_rec(c_workorder_id NUMBER)
192: is
193: SELECT *
194: FROM AHL_ALL_WORKORDERS_V
195: WHERE workorder_id=c_workorder_id;
196:
197: l_prd_workorder_rec AHL_ALL_WORKORDERS_V%ROWTYPE;
198:

Line 197: l_prd_workorder_rec AHL_ALL_WORKORDERS_V%ROWTYPE;

193: SELECT *
194: FROM AHL_ALL_WORKORDERS_V
195: WHERE workorder_id=c_workorder_id;
196:
197: l_prd_workorder_rec AHL_ALL_WORKORDERS_V%ROWTYPE;
198:
199: -- MANESING::Bug 13998940, 26-Apr-2012, added following cursor
200: -- Cursor to fetch instance id for the given work order
201: CURSOR get_instance_id_csr (c_wip_entity_id NUMBER) IS

Line 234: * pick already existing item instance id from Visit Master WO record instead of View AHL_ALL_WORKORDERS_V

230: -- for Visit MWO, derive inventory item and serial number from instance_id.
231: IF (l_prd_workorder_rec.VISIT_TASK_ID IS NULL AND l_prd_workorder_rec.inventory_item_id IS NULL) THEN
232:
233: /* MANESING::Bug 13998940, 26-Apr-2012, For Component Visits,
234: * pick already existing item instance id from Visit Master WO record instead of View AHL_ALL_WORKORDERS_V
235: * which is used above for populating record l_prd_workorder_rec.
236: * The reason behind this is View AHL_ALL_WORKORDERS_V picks Visit's instance id first (null in case no Unit is
237: * associated) and if that is null, then picks instance id of 1st Visit task which could be non-serialized.
238: * Non-serialized instance cannot be used for Component Visit MWO as this causes issues while Returning the

Line 236: * The reason behind this is View AHL_ALL_WORKORDERS_V picks Visit's instance id first (null in case no Unit is

232:
233: /* MANESING::Bug 13998940, 26-Apr-2012, For Component Visits,
234: * pick already existing item instance id from Visit Master WO record instead of View AHL_ALL_WORKORDERS_V
235: * which is used above for populating record l_prd_workorder_rec.
236: * The reason behind this is View AHL_ALL_WORKORDERS_V picks Visit's instance id first (null in case no Unit is
237: * associated) and if that is null, then picks instance id of 1st Visit task which could be non-serialized.
238: * Non-serialized instance cannot be used for Component Visit MWO as this causes issues while Returning the
239: * non-serialized instance due to an Open work order (Visit MWO).
240: * We have explicitly added a workaround to avoid having non-serialized instance in Visit MWO while its creation,