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_PRINT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31


SELECT
 timezone_code
FROM
  fnd_timezones_vl
WHERE
 upgrade_tz_id = fnd_profile.VALUE('SERVER_TIMEZONE_ID');

Line: 40


 SELECT substr(tz_offset(c_tz_code),0,6)
FROM
 dual;

Line: 89


SELECT
  wo.job_number,
  wo.job_description,
  wo.job_status_meaning,
  wo.visit_number,
  wo.organization_name,
  wo.department_name,
  decode(wo.scheduled_start_date, null, null, TO_CHAR(wo.scheduled_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_start_date,
  decode(wo.scheduled_end_date, null, null, TO_CHAR(wo.scheduled_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_end_date,
  decode(wo.actual_start_date, null, null, TO_CHAR(wo.actual_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )actual_start_date,
  decode(wo.actual_end_date, null, null, TO_CHAR(wo.actual_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) actual_end_date,
  wo.unit_name,
  wo.wo_part_number,
  wo.serial_number,
  wo.mr_title,
  ro.ROUTE_NO route_title
FROM
  AHL_SEARCH_WORKORDERS_V wo,
  ahl_routes_app_v ro, ';

Line: 117


SELECT
  decode(ENTERED_DATE, null, null, TO_CHAR(ENTERED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ENTERED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ENTERED_DATE,
  ENTERED_BY_NAME ,
  notes
FROM
  JTF_NOTES_VL
WHERE
  source_object_code = ''AHL_WO_TURNOVER_NOTES'' and
  source_object_id = ';

Line: 129


SELECT
  OPERATION_SEQUENCE_NUM,
  OPERATION_CODE,
  DESCRIPTION,
  STATUS,';

Line: 150


SELECT
  CONCATENATED_SEGMENTS,
  OPERATION_SEQUENCE,
  DESCRIPTION,
  REQUESTED_QUANTITY required_quantity,
  decode(REQUESTED_DATE, null, null, TO_CHAR(REQUESTED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(REQUESTED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) required_date,
  SCHEDULE_QUANTITY,
  decode(SCHEDULE_DATE, null, null, TO_CHAR(SCHEDULE_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULE_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) SCHEDULE_DATE,
  ISSUED_QTY,
  UOM
FROM
  AHL_JOB_OPER_MATERIALS_V
WHERE
  WORKORDER_ID = ';

Line: 168


SELECT
  DOC.DOCUMENT_NO,
  DOC.DOCUMENT_TITLE,
  DOC.ASO_OBJECT_TYPE_DESC,
  DOC.REVISION_NO,
  DOC.CHAPTER,
  DOC.SECTION,
  DOC.SUBJECT,
  DOC.PAGE,
  DOC.FIGURE,
  DOC.NOTE
FROM
  AHL_WORKORDERS WO,
  AHL_DOCUMENT_ASSOS_V DOC
WHERE
  WO.ROUTE_ID = DOC.ASO_OBJECT_ID
  AND DOC.ASO_OBJECT_TYPE_CODE = ''ROUTE''
  AND WO.WORKORDER_ID = ';

Line: 190


SELECT
  DOC.DOCUMENT_NO,
  DOC.DOCUMENT_TITLE,
  DOC.ASO_OBJECT_TYPE_DESC,
  DOC.REVISION_NO,
  DOC.CHAPTER,
  DOC.SECTION,
  DOC.SUBJECT,
  DOC.PAGE,
  DOC.FIGURE,
  DOC.NOTE
FROM
  AHL_WORKORDER_OPERATIONS WOP,
  AHL_DOCUMENT_ASSOS_V DOC
WHERE
  WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
  AND DOC.ASO_OBJECT_TYPE_CODE = ''OPERATION''
  AND WOP.WORKORDER_ID = ';

Line: 212


SELECT
  DOC.DOCUMENT_NO,
  DOC.DOCUMENT_TITLE,
  DOC.ASO_OBJECT_TYPE_DESC,
  DOC.REVISION_NO,
  DOC.CHAPTER,
  DOC.SECTION,
  DOC.SUBJECT,
  DOC.PAGE,
  DOC.FIGURE,
  DOC.NOTE
FROM
  AHL_WORKORDERS WO,
  AHL_VISIT_TASKS_B VST,
  AHL_DOCUMENT_ASSOS_V DOC
WHERE
  WO.VISIT_TASK_ID = VST.VISIT_TASK_ID
  AND VST.MR_ID = DOC.ASO_OBJECT_ID
  AND DOC.ASO_OBJECT_TYPE_CODE = ''MR''
  AND WO.WORKORDER_ID = ';

Line: 237


SELECT
  DOC.DOCUMENT_NO,
  DOC.DOCUMENT_TITLE,
  DOC.ASO_OBJECT_TYPE_DESC,
  DOC.REVISION_NO,
  DOC.CHAPTER,
  DOC.SECTION,
  DOC.SUBJECT,
  DOC.PAGE,
  DOC.FIGURE,
  DOC.NOTE
FROM
  AHL_WORKORDERS WO,
  CSI_II_RELATIONSHIPS CSI,
  AHL_VISIT_TASKS_B VTS,
  AHL_DOCUMENT_ASSOS_V DOC
WHERE
  WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID
  AND VTS.INSTANCE_ID = CSI.SUBJECT_ID
  AND CSI.RELATIONSHIP_TYPE_CODE = ''COMPONENT-OF''
  AND (SYSDATE BETWEEN NVL(CSI.ACTIVE_START_DATE, SYSDATE) AND NVL(CSI.ACTIVE_END_DATE, SYSDATE))
  AND CSI.POSITION_REFERENCE = TO_CHAR(DOC.ASO_OBJECT_ID)
  AND DOC.ASO_OBJECT_TYPE_CODE = ''MC''
  AND WO.WORKORDER_ID = ';

Line: 265


SELECT
  DOC.DOCUMENT_NO,
  DOC.DOCUMENT_TITLE,
  DOC.ASO_OBJECT_TYPE_DESC,
  DOC.REVISION_NO,
  DOC.CHAPTER,
  DOC.SECTION,
  DOC.SUBJECT,
  DOC.PAGE,
  DOC.FIGURE,
  DOC.NOTE
FROM
  AHL_WORKORDERS WO,
  AHL_PC_ASSOCIATIONS PCA,
  AHL_VISIT_TASKS_B VTS,
  AHL_DOCUMENT_ASSOS_V DOC
WHERE
  WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
  AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID
  AND PCA.PC_NODE_ID = DOC.ASO_OBJECT_ID
  AND DOC.ASO_OBJECT_TYPE_CODE = ''PC''
  AND WO.WORKORDER_ID = ';

Line: 290


SELECT DISTINCT
  wass.employee_id,
  pf.full_name employee_name
FROM
  ahl_Work_Assignments wass,
  ahl_Operation_Resources opr,
  ahl_Workorder_Operations wop,
  per_people_f pf,
  per_Person_Types Pt
WHERE
  wass.Operation_Resource_Id = opr.operation_resource_id and
  opr.Workorder_Operation_Id = wop.workorder_operation_id and
  wop.workorder_id = p_wo_id and
  wass.employee_id = nvl(p_employee_id, wass.employee_id) and
  wass.employee_id = pf.PERSON_ID and
  pt.Person_Type_Id  = Pf.Person_Type_Id And
  pt.System_Person_Type ='EMP' And
  ( Trunc(Sysdate) Between Pf.Effective_Start_Date And
  Pf.Effective_End_Date);

Line: 312


SELECT
  workorder_operation_id,
  operation_sequence_num
FROM
  ahl_workorder_operations
WHERE
  workorder_id = p_workorder_id;

Line: 322


SELECT
  PLAN_ID,
  COLLECTION_ID
FROM
  AHL_WORKORDERS
WHERE
  workorder_id = p_workorder_id;

Line: 332


SELECT
  OPERATION_SEQUENCE_NUM, --balaji added for Bug 6777371
  PLAN_ID,
  COLLECTION_ID
FROM
  AHL_WORKORDER_OPERATIONS
WHERE
  workorder_id = p_wo_id;

Line: 564


                  SELECT
                   wop.workorder_id,
                   TO_CHAR(MIN(AHL_PRD_UTIL_PKG.Get_Op_Assigned_Start_Date('||
                      l_emp_tbl(l_count).employee_id ||
                        ',wop.workorder_id
                        ,wop.operation_sequence_num
                        ,''LINE''
                        )),
                   ''YYYY-MM-DD hh:mm:ss+HH:MM'')   Assigned_Start_Date,
                   TO_CHAR(MAX(AHL_PRD_UTIL_PKG.Get_Op_Assigned_Start_Date('||
                      l_emp_tbl(l_count).employee_id ||
                      ',wop.workorder_id
                       ,wop.operation_sequence_num
                      ,''LINE'')),
                   ''YYYY-MM-DD hh:mm:ss+HH:MM'') Assigned_End_Date
                  FROM
                    AHL_WORKORDER_OPERATIONS WOP
                  GROUP BY workorder_id
                ) WODE ';

Line: 1072


  SELECT
    char_id,
    organization_id,
    prompt_sequence ,
    prompt,
    enabled_flag,
    default_value,
    default_value_id,
    result_column_name,
    values_exist_flag,
    displayed_flag,
    plan_name,
    plan_description,
    char_name,
    datatype,
    hardcoded_column,
    developer_name
  FROM
    QA_PLAN_CHARS_V QA
  WHERE
    plan_id = p_plan_id;

Line: 1107


  l_query_string := 'SELECT RESULTS.COLLECTION_ID, RESULTS.OCCURRENCE ';

Line: 1109


  l_dummy_query := ' UNION ALL SELECT null collection_id, null occurrence';

Line: 1259


    l_query_string := ' select
              wo.workorder_id
      from
       ahl_workorders wo,
       wip_discrete_jobs wipd,
       ahl_visits_b vst,
       ahl_visit_tasks_b vtsk
      where
       wo.visit_id = vst.visit_id and
       wo.wip_entity_id = wipd.wip_entity_id and
       wo.visit_task_id = vtsk.visit_task_id and
       vst.visit_id = vtsk.visit_id and
       wo.status_code in (3, 4, 5, 6, 7, 12, 19) and
       wo.master_workorder_flag <> ''Y'' and
       vst.status_code in (''RELEASED'',''PARTIALLY RELEASED'') ';