APPS.AHL_QA_RESULTS_PVT SQL Statements

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

Line: 81

SELECT  plan_id
FROM    QA_RESULTS
WHERE   collection_id = c_collection_id;

Line: 87

SELECT  char_id
FROM    QA_PLAN_CHARS
WHERE   plan_id = c_plan_id;

Line: 95

SELECT WO.job_number,WO.job_status_code status_code,AHL_PRD_UTIL_PKG.Is_Unit_Locked(WO.workorder_id,null,null,null) UNIT_LOCKED
FROM AHL_SEARCH_WORKORDERS_V  WO
WHERE WO.workorder_id = c_wo_id;

Line: 101

SELECT to_char(OPERATION_SEQUENCE_NUM) title,STATUS_CODE,AHL_PRD_UTIL_PKG.IS_UNIT_LOCKED(WOP.WORKORDER_ID,NULL,NULL,NULL) UNIT_LOCKED
FROM ahl_workorder_operations_v WOP
WHERE WORKORDER_OPERATION_ID = c_op_id;

Line: 112

SELECT  MR.MR_TITLE TITLE, MR.STATUS_CODE,AHL_PRD_UTIL_PKG.IS_UNIT_LOCKED(NULL,MR.UNIT_EFFECTIVITY_ID,NULL,NULL) UNIT_LOCKED
FROM    AHL_MR_INSTANCES_V MR
WHERE MR.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;

Line: 141

    SELECT  organization_id
    INTO    l_organization_id
    FROM    QA_PLANS
    WHERE   plan_id = p_plan_id;

Line: 341

    UPDATE AHL_UNIT_EFFECTIVITIES_B
    SET    qa_collection_id = p_collection_id,
           object_version_number = object_version_number + 1,
           last_update_date = SYSDATE,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.login_id
    WHERE  unit_effectivity_id = l_unit_effectivity_id
    AND    object_version_number = l_object_version_number;

Line: 365

    UPDATE AHL_WORKORDERS
    SET    collection_id = p_collection_id,
           object_version_number = object_version_number + 1,
           last_update_date = SYSDATE,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.login_id
    WHERE  workorder_id = l_workorder_id
    AND    object_version_number = l_object_version_number;

Line: 389

    UPDATE AHL_WORKORDER_OPERATIONS
    SET    collection_id = p_collection_id,
           object_version_number = object_version_number + 1,
           last_update_date = SYSDATE,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.login_id
    WHERE  workorder_operation_id = l_workorder_operation_id
    AND    object_version_number = l_object_version_number;

Line: 564

    SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;

Line: 1025

    SELECT   QP.plan_id
    INTO     x_plan_id
    FROM     QA_PLANS_VAL_V QP,
             QA_PLAN_TRANSACTIONS QPT,
             QA_PLAN_COLLECTION_TRIGGERS QPCT
    WHERE    QP.plan_id = QPT.plan_id
    AND      QPT.plan_transaction_id = QPCT.plan_transaction_id
    AND      QP.organization_id = p_organization_id
    AND      QPT.transaction_number = p_transaction_number
    AND      QPCT.collection_trigger_id = 87
    AND      QPCT.low_value = p_col_trigger_value;