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_VWP_TASKS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 575: AHL_VISIT_TASKS_VL ORIGTSK,

571: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
572: FROM AHL_VISITS_B AVTS,
573: AHL_VISIT_TASKS_B ATSK,
574: AHL_VISIT_TASKS_TL ATSKL,
575: AHL_VISIT_TASKS_VL ORIGTSK,
576: AHL_MR_ROUTES AMRR,
577: AHL_MR_HEADERS_VL AMRH,
578: AHL_UNIT_EFFECTIVITIES_B AUEF,
579: CSI_ITEM_INSTANCES CSIS,

Line 703: AHL_VISIT_TASKS_VL ORIGTSK,

699: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
700: FROM AHL_VISITS_B AVTS,
701: AHL_VISIT_TASKS_B ATSK,
702: AHL_VISIT_TASKS_TL ATSKL,
703: AHL_VISIT_TASKS_VL ORIGTSK,
704: AHL_MR_HEADERS_VL AMRH,
705: AHL_UNIT_EFFECTIVITIES_B AUEF,
706: CSI_ITEM_INSTANCES CSIS,
707: CS_INCIDENTS_ALL_B SR,

Line 820: AHL_VISIT_TASKS_VL ATSK,

816: ATSK.Attribute14,
817: ATSK.Attribute15
818: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
819: FROM AHL_VISITS_VL AVTS,
820: AHL_VISIT_TASKS_VL ATSK,
821: AHL_VISIT_TASKS_VL ORIGTSK,
822: CSI_ITEM_INSTANCES CSIS,
823: CS_INCIDENTS_ALL_B SR,
824: AHL_VWP_STAGES_VL ASTG,

Line 821: AHL_VISIT_TASKS_VL ORIGTSK,

817: ATSK.Attribute15
818: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
819: FROM AHL_VISITS_VL AVTS,
820: AHL_VISIT_TASKS_VL ATSK,
821: AHL_VISIT_TASKS_VL ORIGTSK,
822: CSI_ITEM_INSTANCES CSIS,
823: CS_INCIDENTS_ALL_B SR,
824: AHL_VWP_STAGES_VL ASTG,
825: BOM_DEPARTMENTS BDPT,

Line 858: FROM AHL_VISIT_TASKS_VL T1, AHL_VISITS_VL T2

854:
855: -- To find all task related information which is not in visit/template search views
856: CURSOR c_task_data(p_task_id IN NUMBER) IS
857: SELECT T1.*, T2.TEMPLATE_FLAG, T2.ORGANIZATION_ID
858: FROM AHL_VISIT_TASKS_VL T1, AHL_VISITS_VL T2
859: WHERE T1.visit_task_id = p_task_id
860: AND T1.VISIT_ID = T2.VISIT_ID;
861: c_task_data_rec c_task_data%ROWTYPE;
862:

Line 962: FROM AHL_VISIT_TASKS_VL ATSK,

958: AHL_WARRANTY_CONTRACTS_PVT.IS_INSTANCE_WARRANTY_AVAILABLE(ATSK.INSTANCE_ID) INSTANCE_WARRANTY_FLAG,
959: NVL2(TO_NUMBER(ASWE.WARRANTY_ENTITLEMENT_ID)
960: , DECODE(ASWE.ENTITLEMENT_STATUS_CODE, 'NOT_APPLICABLE', 'Y', 'N')
961: , 'Y') WARRANTY_NOT_APPL_FLAG
962: FROM AHL_VISIT_TASKS_VL ATSK,
963: AHL_WARRANTY_ENTITLEMENTS ASWE,
964: AHL_WARRANTY_CLAIMS_B AWCL,
965: AHL_WARRANTY_CONTRACTS_B AWCB,
966: FND_LOOKUP_VALUES_VL LKUP1,

Line 3335: SELECT * FROM Ahl_Visit_Tasks_VL

3331: l_new_structure_flag VARCHAR2(1);
3332:
3333: -- To find task related information
3334: CURSOR c_Task (x_id IN NUMBER) IS
3335: SELECT * FROM Ahl_Visit_Tasks_VL
3336: WHERE VISIT_TASK_ID = x_id;
3337: c_Task_rec c_Task%ROWTYPE;
3338:
3339: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010

Line 3770: from ahl_visit_tasks_vl

3766: ATTRIBUTE14 ,
3767: ATTRIBUTE15 ,
3768: QUANTITY , --Added by rnahata for Issue 105
3769: STAGE_ID
3770: from ahl_visit_tasks_vl
3771: where visit_task_id = p_visit_task_id;
3772:
3773: l_old_Task_rec c_visit_task_det%rowtype;
3774:

Line 3791: FROM Ahl_Visit_Tasks_VL

3787:
3788: -- To find all tasks under this current visit related information
3789: CURSOR c_all_Task (x_id IN NUMBER) IS
3790: SELECT *
3791: FROM Ahl_Visit_Tasks_VL
3792: WHERE VISIT_TASK_ID = x_id;
3793: l_all_Task_rec c_all_Task%ROWTYPE;
3794:
3795: l_workrec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

Line 4309: from ahl_visit_tasks_vl

4305: ATTRIBUTE14 ,
4306: ATTRIBUTE15 ,
4307: QUANTITY , --Added by rnahata for Issue 105
4308: STAGE_ID
4309: from ahl_visit_tasks_vl
4310: where visit_task_id = p_visit_task_id;
4311:
4312: l_old_Task_rec c_visit_task_det%rowtype;
4313:

Line 4639: SELECT * FROM Ahl_Visit_Tasks_VL

4635: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
4636:
4637: -- To find task related information
4638: CURSOR c_Task (x_id IN NUMBER) IS
4639: SELECT * FROM Ahl_Visit_Tasks_VL
4640: WHERE VISIT_TASK_ID = x_id;
4641: c_Task_rec c_Task%ROWTYPE;
4642: c_upd_Task_rec c_Task%ROWTYPE;
4643:

Line 5295: SELECT * FROM Ahl_Visit_Tasks_VL

5291: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
5292:
5293: -- To find task related information
5294: CURSOR c_Task (x_id IN NUMBER) IS
5295: SELECT * FROM Ahl_Visit_Tasks_VL
5296: WHERE VISIT_TASK_ID = x_id;
5297: c_Task_rec c_Task%ROWTYPE;
5298:
5299: -- To find visit related information

Line 5862: SELECT * FROM Ahl_Visit_Tasks_VL

5858: l_msg_count NUMBER;
5859:
5860: -- To find task related information
5861: CURSOR c_Task (x_id IN NUMBER) IS
5862: SELECT * FROM Ahl_Visit_Tasks_VL
5863: WHERE VISIT_TASK_ID = x_id;
5864: c_Task_rec c_Task%ROWTYPE;
5865:
5866: -- To find visit related information

Line 6418: SELECT * FROM Ahl_Visit_Tasks_VL

6414: l_return_status VARCHAR2(1);
6415:
6416: -- To find all tasks related information
6417: CURSOR c_Task (x_id IN NUMBER) IS
6418: SELECT * FROM Ahl_Visit_Tasks_VL
6419: WHERE Visit_Task_ID = x_id;
6420: c_task_rec c_Task%ROWTYPE;
6421:
6422: -- To find visit related information

Line 6433: FROM Ahl_Visit_Tasks_VL

6429: -- To find any task which have primary visit task id as deleted task id
6430: --CURSOR c_primary (x_visit_id IN NUMBER, x_task_id IN NUMBER) IS
6431: CURSOR c_primary (x_task_id IN NUMBER) IS
6432: SELECT Visit_Task_Id, Object_Version_Number,visit_id
6433: FROM Ahl_Visit_Tasks_VL
6434: WHERE --VISIT_ID = x_visit_id AND
6435: PRIMARY_VISIT_TASK_ID = x_task_id
6436: AND status_code <> 'DELETED';
6437: c_primary_rec c_primary%ROWTYPE;

Line 6856: FROM Ahl_Visit_Tasks_VL

6852:
6853: -- To find all tasks related information
6854: CURSOR c_Task (x_id IN NUMBER) IS
6855: SELECT *
6856: FROM Ahl_Visit_Tasks_VL
6857: WHERE Visit_Task_ID = x_id;
6858: c_task_rec c_Task%ROWTYPE;
6859:
6860: -- To find visit related information

Line 6871: FROM Ahl_Visit_Tasks_VL

6867: -- To find any task which have primary visit task id as deleted task id
6868: --CURSOR c_primary (x_visit_id IN NUMBER, x_task_id IN NUMBER) IS
6869: CURSOR c_primary (x_task_id IN NUMBER) IS
6870: SELECT Visit_Task_Id, Object_Version_Number
6871: FROM Ahl_Visit_Tasks_VL
6872: WHERE --VISIT_ID = x_visit_id AND
6873: PRIMARY_VISIT_TASK_ID = x_task_id
6874: AND STATUS_CODE <> 'DELETED';
6875: c_primary_rec c_primary%ROWTYPE;

Line 7367: FROM Ahl_Visit_Tasks_VL

7363:
7364: -- To find all tasks related information
7365: CURSOR c_Task (x_id IN NUMBER) IS
7366: SELECT *
7367: FROM Ahl_Visit_Tasks_VL
7368: WHERE Visit_Task_ID = x_id;
7369: c_task_rec c_Task%ROWTYPE;
7370: l_task_rec c_Task%ROWTYPE;
7371: -- To find visit related information

Line 8585: FROM Ahl_Visit_Tasks_vl

8581: )
8582: IS
8583: CURSOR c_Visit_Task IS
8584: SELECT *
8585: FROM Ahl_Visit_Tasks_vl
8586: WHERE Visit_Task_ID = p_task_rec.Visit_Task_ID;
8587: --
8588: -- This is the only exception for using %ROWTYPE.
8589: -- We are selecting from the VL view, which may

Line 8760: 'Ahl_Visit_Tasks_vl',

8756: END IF;
8757:
8758: -- FOR CREATION
8759: IF Ahl_Utility_Pvt.check_uniqueness(
8760: 'Ahl_Visit_Tasks_vl',
8761: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
8762: ) = Fnd_Api.g_false
8763: THEN
8764: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 10299: SELECT * FROM Ahl_Visit_Tasks_VL

10295: l_return_status VARCHAR2(1);
10296:
10297: -- To find all tasks related information
10298: CURSOR c_Task (x_id IN NUMBER) IS
10299: SELECT * FROM Ahl_Visit_Tasks_VL
10300: WHERE Visit_Task_ID = x_id;
10301: c_task_rec c_Task%ROWTYPE;
10302:
10303: -- To find visit related information

Line 10314: FROM Ahl_Visit_Tasks_VL

10310: -- To find any task which have primary visit task id as deleted task id
10311: --CURSOR c_primary (x_visit_id IN NUMBER, x_task_id IN NUMBER) IS
10312: CURSOR c_primary (x_task_id IN NUMBER) IS
10313: SELECT Visit_Task_Id, Object_Version_Number,visit_id
10314: FROM Ahl_Visit_Tasks_VL
10315: WHERE --VISIT_ID = x_visit_id AND
10316: PRIMARY_VISIT_TASK_ID = x_task_id
10317: AND status_code <> 'DELETED';
10318: c_primary_rec c_primary%ROWTYPE;

Line 10344: from AHL_VISIT_TASKS_VL

10340: -- Comment the below since this validation is not needed as this API is only called in visit cancellation flow
10341: /*CURSOR c_stage_tasks_count (c_visit_id IN NUMBER, c_stage_id IN NUMBER)
10342: IS
10343: select count(1) as TASK_COUNT
10344: from AHL_VISIT_TASKS_VL
10345: where VISIT_ID = c_visit_id
10346: AND TASK_TYPE_CODE <> 'STAGE'
10347: AND STAGE_ID = c_stage_id;
10348: