APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 1505: l_status AHL_WORKORDER_OPERATIONS_V.STATUS%type;

1501: l_wo_oper_id NUMBER;
1502: l_org_id NUMBER;
1503: l_oper_seq NUMBER;
1504: l_wo_id NUMBER;
1505: l_status AHL_WORKORDER_OPERATIONS_V.STATUS%type;
1506: l_desc AHL_WORKORDER_OPERATIONS_V.DESCRIPTION%type;
1507: l_dept_id NUMBER;
1508:
1509: BEGIN

Line 1506: l_desc AHL_WORKORDER_OPERATIONS_V.DESCRIPTION%type;

1502: l_org_id NUMBER;
1503: l_oper_seq NUMBER;
1504: l_wo_id NUMBER;
1505: l_status AHL_WORKORDER_OPERATIONS_V.STATUS%type;
1506: l_desc AHL_WORKORDER_OPERATIONS_V.DESCRIPTION%type;
1507: l_dept_id NUMBER;
1508:
1509: BEGIN
1510:

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

1513: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1514: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, WORKORDER_OPERATION_ID, ';
1515: l_sql_string := l_sql_string || ' ORGANIZATION_ID, OPERATION_SEQUENCE_NUM, ';
1516: l_sql_string := l_sql_string || ' WORKORDER_ID, STATUS, DESCRIPTION, DEPARTMENT_ID ';
1517: l_sql_string := l_sql_string || ' FROM AHL_WORKORDER_OPERATIONS_V ';
1518: l_sql_string := l_sql_string || ' WHERE 0=0 ';
1519:
1520: --Get Dynamic Search Criteria
1521: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;