APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 1650: l_status AHL_WORKORDER_OPERATIONS_V.STATUS%type;

1646: l_wo_oper_id NUMBER;
1647: l_org_id NUMBER;
1648: l_oper_seq NUMBER;
1649: l_wo_id NUMBER;
1650: l_status AHL_WORKORDER_OPERATIONS_V.STATUS%type;
1651: l_desc AHL_WORKORDER_OPERATIONS_V.DESCRIPTION%type;
1652: l_dept_id NUMBER;
1653:
1654: BEGIN

Line 1651: l_desc AHL_WORKORDER_OPERATIONS_V.DESCRIPTION%type;

1647: l_org_id NUMBER;
1648: l_oper_seq NUMBER;
1649: l_wo_id NUMBER;
1650: l_status AHL_WORKORDER_OPERATIONS_V.STATUS%type;
1651: l_desc AHL_WORKORDER_OPERATIONS_V.DESCRIPTION%type;
1652: l_dept_id NUMBER;
1653:
1654: BEGIN
1655:

Line 1662: l_sql_string := l_sql_string || ' FROM AHL_WORKORDER_OPERATIONS_V ';

1658: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1659: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, WORKORDER_OPERATION_ID, ';
1660: l_sql_string := l_sql_string || ' ORGANIZATION_ID, OPERATION_SEQUENCE_NUM, ';
1661: l_sql_string := l_sql_string || ' WORKORDER_ID, STATUS, DESCRIPTION, DEPARTMENT_ID ';
1662: l_sql_string := l_sql_string || ' FROM AHL_WORKORDER_OPERATIONS_V ';
1663: l_sql_string := l_sql_string || ' WHERE 0=0 ';
1664:
1665: --Get Dynamic Search Criteria
1666: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;