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_VISITS_B

Line 287: AHL_VISITS_B VST,

283: VST.PROJECT_ID PROJECT_ID,
284: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,
285: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
286: FROM AHL_WORKORDERS WO,
287: AHL_VISITS_B VST,
288: AHL_VISIT_TASKS_B VTS,
289: WIP_DISCRETE_JOBS WIP
290: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
291: AND WO.VISIT_ID = VST.VISIT_ID

Line 572: FROM AHL_VISITS_B AVTS,

568: ATSK.Attribute13,
569: ATSK.Attribute14,
570: ATSK.Attribute15
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,

Line 700: FROM AHL_VISITS_B AVTS,

696: ATSK.Attribute13,
697: ATSK.Attribute14,
698: ATSK.Attribute15
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,

Line 1613: UPDATE AHL_VISITS_B

1609: END IF; -- Visit check
1610:
1611: --SKPATHAK :: Bug 13874699 :: 22-MAR-2012 :: Moved the below piece of code from after the plan visit call to before that call
1612: IF c_visit_rec.STATUS_CODE = 'RELEASED' THEN
1613: UPDATE AHL_VISITS_B
1614: SET STATUS_CODE = 'PARTIALLY RELEASED',
1615: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1
1616: WHERE VISIT_ID =c_visit_rec.VISIT_ID ;
1617: END IF;

Line 3342: SELECT start_date_time, close_date_time FROM ahl_visits_b

3338:
3339: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010
3340: -- get the start date and planned end date of the visit
3341: CURSOR c_Visit (x_id IN NUMBER) IS
3342: SELECT start_date_time, close_date_time FROM ahl_visits_b
3343: WHERE VISIT_ID = x_id;
3344: c_visit_rec c_Visit%ROWTYPE;
3345:
3346:

Line 3924: UPDATE AHL_VISITS_B

3920: CLOSE c_job;
3921:
3922: IF l_count > 0 THEN
3923: -- To update visit's prices
3924: UPDATE AHL_VISITS_B
3925: SET ACTUAL_PRICE = NULL, ESTIMATED_PRICE = NULL,
3926: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3927: WHERE VISIT_ID = l_visit_rec.visit_id;
3928:

Line 4317: from ahl_visits_b

4313:
4314: Cursor c_any_task_flg(p_visit_id in number)
4315: is
4316: Select any_task_chg_flag
4317: from ahl_visits_b
4318: where visit_id = p_visit_id;
4319:
4320: l_any_task_chg_flag ahl_visits_b.any_task_chg_flag%type;
4321:

Line 4320: l_any_task_chg_flag ahl_visits_b.any_task_chg_flag%type;

4316: Select any_task_chg_flag
4317: from ahl_visits_b
4318: where visit_id = p_visit_id;
4319:
4320: l_any_task_chg_flag ahl_visits_b.any_task_chg_flag%type;
4321:
4322: l_return_status VARCHAR2(1);
4323: l_cost_parent_id NUMBER;
4324: l_msg_data VARCHAR2(2000);

Line 6197: UPDATE ahl_visits_b

6193: IF (c_visit_task_exists%NOTFOUND and
6194: c_visit_rec.start_date_time = c_get_wo_details_rec.scheduled_start_date and
6195: c_visit_rec.close_date_time = c_get_wo_details_rec.scheduled_completion_date)
6196: THEN
6197: UPDATE ahl_visits_b
6198: SET status_code = 'RELEASED',
6199: object_version_number = object_version_number + 1
6200: WHERE visit_id = c_visit_rec.visit_id;
6201: END IF;

Line 7268: UPDATE ahl_visits_b

7264:
7265: l_act_price:= NVL(c_visit_rec.actual_price,0) - NVL(l_act_price,0);
7266: l_est_price:= NVL(c_visit_rec.estimated_price,0) - NVL(l_est_price,0);
7267:
7268: UPDATE ahl_visits_b
7269: SET actual_price=l_act_price,
7270: estimated_price=l_est_price,
7271: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
7272: WHERE visit_id=l_visit_id;

Line 7916: UPDATE ahl_visits_b

7912:
7913: l_act_price:= NVL(c_visit_rec.actual_price,0) - NVL(l_act_price,0);
7914: l_est_price:= NVL(c_visit_rec.estimated_price,0) - NVL(l_est_price,0);
7915:
7916: UPDATE ahl_visits_b
7917: SET actual_price=l_act_price,
7918: estimated_price=l_est_price,
7919: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
7920: WHERE visit_id=l_visit_id;

Line 9245: UPDATE AHL_VISITS_B

9241: END IF;
9242: --VWPE :: tchimira :: 19-FEB -2011 :: end
9243:
9244: IF c_visit_rec.STATUS_CODE = 'RELEASED' THEN
9245: UPDATE AHL_VISITS_B
9246: SET STATUS_CODE = 'PARTIALLY RELEASED',
9247: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1
9248: WHERE VISIT_ID =c_visit_rec.VISIT_ID ;
9249: END IF;

Line 9658: FROM ahl_visits_b

9654: J NUMBER;
9655:
9656: CURSOR c_get_Item_Instance(p_visit_id NUMBER) IS
9657: SELECT ITEM_INSTANCE_ID
9658: FROM ahl_visits_b
9659: WHERE visit_id = p_visit_id;
9660:
9661: -- SKPATHAK :: AVF ER: 13416865 :: 25-NOV-2011
9662: -- Do not fetch the planned MRs for automatic addition to visits

Line 9971: FROM ahl_visits_b

9967: -- To validate the passed visit id
9968: Cursor val_visit (x_visit_id IN NUMBER)
9969: IS
9970: SELECT 'X'
9971: FROM ahl_visits_b
9972: WHERE visit_id = x_visit_id;
9973:
9974: -- To fetch visit details
9975: CURSOR Get_Visit_Details (x_visit_id IN NUMBER) IS

Line 9977: FROM ahl_visits_b

9973:
9974: -- To fetch visit details
9975: CURSOR Get_Visit_Details (x_visit_id IN NUMBER) IS
9976: SELECT item_organization_id item_org_id, inventory_item_id item_id, item_instance_id instance_id, status_code
9977: FROM ahl_visits_b
9978: WHERE visit_id = x_visit_id;
9979:
9980: -- TCHIMIRA :: 04-May-2012 :: Bug 14009280 :: START
9981: Cursor get_stage_dates (c_stage_id IN NUMBER) IS

Line 9988: FROM ahl_visits_b

9984: WHERE stage_id = c_stage_id;
9985:
9986: Cursor get_visit_dates (c_visit_id IN NUMBER) IS
9987: SELECT start_date_time, close_date_time
9988: FROM ahl_visits_b
9989: WHERE visit_id = c_visit_id;
9990:
9991: l_task_start_date DATE;
9992: l_task_end_date DATE;

Line 10178: UPDATE AHL_VISITS_B

10174:
10175: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: Automatically create draft WOs if tasks are added to a visit that is in any of the below three statuses
10176: IF visit_details_rec.status_code IN ('PLANNING', 'PARTIALLY RELEASED', 'RELEASED') THEN
10177: -- If the visit status is released, then change the status to partially released due to the addition of stage task to the visit
10178: UPDATE AHL_VISITS_B
10179: SET STATUS_CODE = 'PARTIALLY RELEASED',
10180: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10181: LAST_UPDATE_DATE = SYSDATE,
10182: LAST_UPDATED_BY = Fnd_Global.USER_ID,