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

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

Line: 39


Select plan_id,collection_id  from ahl_search_workorders_v
WHERE workorder_id = p_Workorder_Id;

Line: 43


Select plan_id,collection_id  from ahl_workorder_operations_v
WHERE workorder_operation_id = p_WoOperationId;

Line: 53


SELECT char_id , prompt_sequence
       , prompt, enabled_flag , default_value
       , default_value_id , result_column_name
        , DECODE( NVL( sql_string_flag, 'N' ), 'N', DECODE( hardcoded_column, NULL, 'N', DECODE( QA_SS_LOV_API.get_lov_sql( plan_id, char_id, organization_id, null, null, null, null, null ), NULL, 'N', 'Y' ) ), sql_string_flag )    sql_string_flag
    , values_exist_flag, displayed_flag
    , char_name , datatype , display_length, hardcoded_column
    , developer_name , mandatory_flag
FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;

Line: 63


SELECT plan_id , organization_id,  name
    , description FROM QA_PLANS_V
WHERE plan_id = p_plan_id;

Line: 68


SELECT WO.JOB_NUMBER,
       AMH.TITLE MR_TITLE,
       WOP.OPERATION_SEQUENCE_NUM,
       WOP.STATUS_CODE,
       WO.JOB_STATUS_CODE,
       WO.WO_PART_NUMBER,
       WO.ITEM_INSTANCE_NUMBER,
       WO.LOT_NUMBER,
       WO.SERIAL_NUMBER
FROM AHL_WORKORDERS_V WO, AHL_WORKORDER_OPERATIONS WOP,
AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
AND WO.WORKORDER_ID = WOP.WORKORDER_ID
AND WOP.workorder_operation_id = p_WoOperationId;

Line: 87


SELECT WO.JOB_NUMBER,
       AMH.TITLE MR_TITLE,
       WO.JOB_STATUS_CODE,
       WO.WO_PART_NUMBER,
       WO.ITEM_INSTANCE_NUMBER,
       WO.LOT_NUMBER,
       WO.SERIAL_NUMBER
FROM AHL_WORKORDERS_V WO,
AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
AND WO.WORKORDER_ID = p_Workorder_Id;

Line: 328


Select WORKORDER_ID FROM AHL_WORKORDERS
WHERE WORKORDER_NAME = p_workorder_number;

Line: 350


Select WORKORDER_OPERATION_ID FROM AHL_WORKORDER_OPERATIONS
WHERE WORKORDER_ID = p_Workorder_Id AND
      OPERATION_SEQUENCE_NUM = p_operation_sequence;

Line: 372


SELECT char_id , prompt_sequence
       , prompt, enabled_flag , default_value
       , default_value_id , result_column_name
        , DECODE( NVL( sql_string_flag, 'N' ), 'N', DECODE( hardcoded_column, NULL, 'N', DECODE( QA_SS_LOV_API.get_lov_sql( plan_id, char_id, organization_id, null, null, null, null, null ), NULL, 'N', 'Y' ) ), sql_string_flag )    sql_string_flag
    , values_exist_flag, displayed_flag
    , char_name , datatype , display_length, hardcoded_column
    , developer_name , mandatory_flag
FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;

Line: 387


   l_sql_string := 'SELECT RESULTS.OCCURRENCE ';

Line: 403


          l_result_column_name := '(Select ' ||l_result_column_name || ' FROM  MTL_SYSTEM_ITEMS_KFV ITEM '
                        || ' WHERE ITEM.inventory_item_id  = RESULTS.'|| qa_plan_attributes.hardcoded_column
                        || ' AND ITEM.organization_id  = RESULTS.organization_id ) ' || l_result_column;

Line: 410


          l_result_column_name := '(Select ' || l_result_column_name ||' FROM  MTL_ITEM_LOCATIONS_KFV LOCATOR '
                        || ' WHERE LOCATOR.inventory_location_id  = RESULTS.' || qa_plan_attributes.hardcoded_column
                        + ' AND LOCATOR.organization_id  = RESULTS.organization_id ) ' || l_result_column;

Line: 442


SELECT lookup_code
FROM fnd_Lookups
WHERE lookup_type = 'AHL_JOB_STATUS'
AND meaning = status;

Line: 449


SELECT 1
FROM AHL_STATUS_ORDER_RULES
WHERE  system_status_type = 'AHL_JOB_STATUS'
AND CURRENT_STATUS_CODE = c_status_old
AND NEXT_STATUS_CODE    = c_status_new;

Line: 548


    l_prd_workorder_rec.LAST_UPDATE_DATE := p_x_workorder_rec.LAST_UPDATED_DATE;

Line: 549


    l_prd_workorder_rec.LAST_UPDATED_BY := p_x_workorder_rec.LAST_UPDATED_BY;

Line: 552


    l_prd_workorder_rec.LAST_UPDATE_LOGIN := p_x_workorder_rec.LAST_UPDATE_LOGIN;

Line: 567


    AHL_PRD_WORKORDER_PVT.update_job
    (
        p_api_version          => 1.0 ,
        p_init_msg_list        =>  FND_API.G_TRUE,
        p_commit               =>  FND_API.G_FALSE,
        p_validation_level     =>  FND_API.G_VALID_LEVEL_FULL,
        p_default              =>  FND_API.G_TRUE,
        p_module_type          =>  'API',
        x_return_status        => x_return_status,
        x_msg_count            => x_msg_count,
        x_msg_data             => x_msg_data,
        p_wip_load_flag        => 'Y',
        p_x_prd_workorder_rec  => l_prd_workorder_rec,
        p_x_prd_workoper_tbl   => l_prd_workoper_tbl
     );

Line: 635


    p_x_workorder_rec.LAST_UPDATED_DATE := l_prd_workorder_rec.LAST_UPDATE_DATE;

Line: 636


    p_x_workorder_rec.LAST_UPDATED_BY := l_prd_workorder_rec.LAST_UPDATED_BY;

Line: 639


    p_x_workorder_rec.LAST_UPDATE_LOGIN := l_prd_workorder_rec.LAST_UPDATE_LOGIN;

Line: 732


    l_prd_workorder_rec.LAST_UPDATE_DATE := p_x_workorder_rec.LAST_UPDATED_DATE;

Line: 733


    l_prd_workorder_rec.LAST_UPDATED_BY := p_x_workorder_rec.LAST_UPDATED_BY;

Line: 736


    l_prd_workorder_rec.LAST_UPDATE_LOGIN := p_x_workorder_rec.LAST_UPDATE_LOGIN;

Line: 751


    AHL_PRD_WORKORDER_PVT.update_job
    (
        p_api_version          => 1.0 ,
        p_init_msg_list        =>  FND_API.G_TRUE,
        p_commit               =>  FND_API.G_FALSE,
        p_validation_level     =>  FND_API.G_VALID_LEVEL_FULL,
        p_default              =>  FND_API.G_TRUE,
        p_module_type          =>  'API',
        x_return_status        => x_return_status,
        x_msg_count            => x_msg_count,
        x_msg_data             => x_msg_data,
        p_wip_load_flag        => 'Y',
        p_x_prd_workorder_rec  => l_prd_workorder_rec,
        p_x_prd_workoper_tbl   => l_prd_workoper_tbl
     );

Line: 819


    p_x_workorder_rec.LAST_UPDATED_DATE := l_prd_workorder_rec.LAST_UPDATE_DATE;

Line: 820


    p_x_workorder_rec.LAST_UPDATED_BY := l_prd_workorder_rec.LAST_UPDATED_BY;

Line: 823


    p_x_workorder_rec.LAST_UPDATE_LOGIN := l_prd_workorder_rec.LAST_UPDATE_LOGIN;

Line: 917


    l_prd_workorder_rec.LAST_UPDATE_DATE := p_x_workorder_rec.LAST_UPDATED_DATE;

Line: 918


    l_prd_workorder_rec.LAST_UPDATED_BY := p_x_workorder_rec.LAST_UPDATED_BY;

Line: 921


    l_prd_workorder_rec.LAST_UPDATE_LOGIN := p_x_workorder_rec.LAST_UPDATE_LOGIN;

Line: 936


    AHL_PRD_WORKORDER_PVT.update_job
    (
        p_api_version          => 1.0 ,
        p_init_msg_list        =>  FND_API.G_TRUE,
        p_commit               =>  FND_API.G_FALSE,
        p_validation_level     =>  FND_API.G_VALID_LEVEL_FULL,
        p_default              =>  FND_API.G_TRUE,
        p_module_type          =>  'API',
        x_return_status        => x_return_status,
        x_msg_count            => x_msg_count,
        x_msg_data             => x_msg_data,
        p_wip_load_flag        => 'Y',
        p_x_prd_workorder_rec  => l_prd_workorder_rec,
        p_x_prd_workoper_tbl   => l_prd_workoper_tbl
     );

Line: 1004


    p_x_workorder_rec.LAST_UPDATED_DATE := l_prd_workorder_rec.LAST_UPDATE_DATE;

Line: 1005


    p_x_workorder_rec.LAST_UPDATED_BY := l_prd_workorder_rec.LAST_UPDATED_BY;

Line: 1008


    p_x_workorder_rec.LAST_UPDATE_LOGIN := l_prd_workorder_rec.LAST_UPDATE_LOGIN;

Line: 1107


    l_prd_workorder_rec.LAST_UPDATE_DATE := p_x_workorder_rec.LAST_UPDATED_DATE;

Line: 1108


    l_prd_workorder_rec.LAST_UPDATED_BY := p_x_workorder_rec.LAST_UPDATED_BY;

Line: 1111


    l_prd_workorder_rec.LAST_UPDATE_LOGIN := p_x_workorder_rec.LAST_UPDATE_LOGIN;

Line: 1126


    AHL_PRD_WORKORDER_PVT.update_job
    (
        p_api_version          => 1.0 ,
        p_init_msg_list        =>  FND_API.G_TRUE,
        p_commit               =>  FND_API.G_FALSE,
        p_validation_level     =>  FND_API.G_VALID_LEVEL_FULL,
        p_default              =>  FND_API.G_TRUE,
        p_module_type          =>  'API',
        x_return_status        => x_return_status,
        x_msg_count            => x_msg_count,
        x_msg_data             => x_msg_data,
        p_wip_load_flag        => 'Y',
        p_x_prd_workorder_rec  => l_prd_workorder_rec,
        p_x_prd_workoper_tbl   => l_prd_workoper_tbl
     );

Line: 1194


    p_x_workorder_rec.LAST_UPDATED_DATE := l_prd_workorder_rec.LAST_UPDATE_DATE;

Line: 1195


    p_x_workorder_rec.LAST_UPDATED_BY := l_prd_workorder_rec.LAST_UPDATED_BY;

Line: 1198


    p_x_workorder_rec.LAST_UPDATE_LOGIN := l_prd_workorder_rec.LAST_UPDATE_LOGIN;

Line: 1330


SELECT object_version_number,status_code FROM AHL_WORKORDER_OPERATIONS
WHERE WORKORDER_OPERATION_ID = p_WoOperationId;

Line: 1341


SELECT lookup_code
FROM   FND_LOOKUP_VALUES_VL
WHERE  lookup_type='AHL_OPERATION_STATUS'
AND    UPPER(meaning)=UPPER(c_operation_status)
AND    TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))
                      AND TRUNC(NVL(end_date_active,SYSDATE+1));

Line: 1350


SELECT 'x' FROM AHL_WORKORDERS AWOS
WHERE AWOS.workorder_id = c_wo_id
AND AWOS.route_id IS NULL;

Line: 1441


    l_prd_operation_tbl(j).LAST_UPDATE_LOGIN := p_x_Operations(i).LAST_UPDATE_LOGIN;

Line: 1442


    l_prd_operation_tbl(j).LAST_UPDATE_DATE := p_x_Operations(i).LAST_UPDATED_DATE;

Line: 1443


    l_prd_operation_tbl(j).LAST_UPDATED_BY := p_x_Operations(i).LAST_UPDATED_BY;

Line: 1504


     l_out_Operations(j).LAST_UPDATE_LOGIN := l_prd_operation_tbl(i).LAST_UPDATE_LOGIN;

Line: 1505


     l_out_Operations(j).LAST_UPDATED_DATE := l_prd_operation_tbl(i).LAST_UPDATE_DATE;

Line: 1506


     l_out_Operations(j).LAST_UPDATED_BY := l_prd_operation_tbl(i).LAST_UPDATED_BY;

Line: 1596


    l_req_material_tbl(j).LAST_UPDATED_DATE := p_x_MaterialRequirements(i).LAST_UPDATED_DATE;

Line: 1654


    p_x_MaterialRequirements(j).LAST_UPDATED_DATE := l_req_material_tbl(i).LAST_UPDATED_DATE;

Line: 1950


     l_cre_res_reqmts(j).LAST_UPDATE_LOGIN := p_x_ResourceRequirements(i).LAST_UPDATE_LOGIN;

Line: 1951


     l_cre_res_reqmts(j).LAST_UPDATED_DATE := p_x_ResourceRequirements(i).LAST_UPDATED_DATE;

Line: 1952


     l_cre_res_reqmts(j).LAST_UDDATED_BY := p_x_ResourceRequirements(i).LAST_UPDATED_BY;

Line: 2014


     l_upd_res_reqmts(k).LAST_UPDATE_LOGIN := p_x_ResourceRequirements(i).LAST_UPDATE_LOGIN;

Line: 2015


     l_upd_res_reqmts(k).LAST_UPDATED_DATE := p_x_ResourceRequirements(i).LAST_UPDATED_DATE;

Line: 2016


     l_upd_res_reqmts(k).LAST_UDDATED_BY := p_x_ResourceRequirements(i).LAST_UPDATED_BY;

Line: 2130


     p_x_ResourceRequirements(j).LAST_UPDATE_LOGIN := l_upd_res_reqmts(i).LAST_UPDATE_LOGIN;

Line: 2131


     p_x_ResourceRequirements(j).LAST_UPDATED_DATE := l_upd_res_reqmts(i).LAST_UPDATED_DATE;

Line: 2132


     p_x_ResourceRequirements(j).LAST_UPDATED_BY := l_upd_res_reqmts(i).LAST_UDDATED_BY;

Line: 2208


     p_x_ResourceRequirements(j).LAST_UPDATE_LOGIN := l_cre_res_reqmts(i).LAST_UPDATE_LOGIN;

Line: 2209


     p_x_ResourceRequirements(j).LAST_UPDATED_DATE := l_cre_res_reqmts(i).LAST_UPDATED_DATE;

Line: 2210


     p_x_ResourceRequirements(j).LAST_UPDATED_BY := l_cre_res_reqmts(i).LAST_UDDATED_BY;

Line: 2284


     l_cre_res_assmts(j).LAST_UPDATE_LOGIN := p_x_ResourceAssignments(i).LAST_UPDATE_LOGIN;

Line: 2285


     l_cre_res_assmts(j).LAST_UPDATED_DATE := p_x_ResourceAssignments(i).LAST_UPDATED_DATE;

Line: 2286


     l_cre_res_assmts(j).LAST_UDDATED_BY := p_x_ResourceAssignments(i).LAST_UPDATED_BY;

Line: 2329


     l_upd_res_assmts(k).LAST_UPDATE_LOGIN := p_x_ResourceAssignments(i).LAST_UPDATE_LOGIN;

Line: 2330


     l_upd_res_assmts(k).LAST_UPDATED_DATE := p_x_ResourceAssignments(i).LAST_UPDATED_DATE;

Line: 2331


     l_upd_res_assmts(k).LAST_UDDATED_BY := p_x_ResourceAssignments(i).LAST_UPDATED_BY;

Line: 2425


     p_x_ResourceAssignments(j).LAST_UPDATE_LOGIN := l_upd_res_assmts(i).LAST_UPDATE_LOGIN;

Line: 2426


     p_x_ResourceAssignments(j).LAST_UPDATED_DATE := l_upd_res_assmts(i).LAST_UPDATED_DATE;

Line: 2427


     p_x_ResourceAssignments(j).LAST_UPDATED_BY := l_upd_res_assmts(i).LAST_UDDATED_BY;

Line: 2488


     p_x_ResourceAssignments(j).LAST_UPDATE_LOGIN := l_cre_res_assmts(i).LAST_UPDATE_LOGIN;

Line: 2489


     p_x_ResourceAssignments(j).LAST_UPDATED_DATE := l_cre_res_assmts(i).LAST_UPDATED_DATE;

Line: 2490


     p_x_ResourceAssignments(j).LAST_UPDATED_BY := l_cre_res_assmts(i).LAST_UDDATED_BY;

Line: 2532


SELECT lookup_code
FROM fnd_Lookups
WHERE lookup_type = 'AHL_JOB_STATUS'
AND meaning = status;

Line: 2616


    l_prd_workorder_rec.LAST_UPDATE_DATE := p_x_workorder_rec.LAST_UPDATED_DATE;

Line: 2617


    l_prd_workorder_rec.LAST_UPDATED_BY := p_x_workorder_rec.LAST_UPDATED_BY;

Line: 2620


    l_prd_workorder_rec.LAST_UPDATE_LOGIN := p_x_workorder_rec.LAST_UPDATE_LOGIN;

Line: 2678


SELECT WORKORDER_ID,WIP_ENTITY_ID,OBJECT_VERSION_NUMBER,JOB_NUMBER,ORGANIZATION_ID,
       DEPARTMENT_ID,JOB_STATUS_CODE,PLAN_ID,COLLECTION_ID
FROM ahl_search_workorders_v
WHERE WORKORDER_ID = p_workorder_id;