APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on AHL_WORKORDERS_V

Line 217: --Function is used mainly in ahl workorders view to get serial tag code

213: END IF;
214:
215: END IF; /* for serial number control */
216: END Validate_SerialNumber;
217: --Function is used mainly in ahl workorders view to get serial tag code
218: FUNCTION get_serialtag_code
219: (
220: p_instance_id IN NUMBER
221: ) RETURN VARCHAR2

Line 286: --Function is used mainly in ahl workorders view to get serial tag code

282: END IF;
283:
284: END get_serialtag_code;
285:
286: --Function is used mainly in ahl workorders view to get serial tag code
287: FUNCTION get_serialtag_meaning
288: (
289: p_instance_id IN NUMBER
290: ) RETURN VARCHAR2

Line 402: ahl_workorders_v

398: item_instance_number,
399: organization_id,
400: inventory_item_id
401: FROM
402: ahl_workorders_v
403: WHERE
404: (workorder_id = c_workorder_id
405: OR job_number = c_job_number)
406: AND job_status_code not in (1,4,5,7,12,14,17);