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_OSP_SHIPMENT_PUB dependencies on AHL_VISIT_TASKS_B

Line 2086: ahl_visit_tasks_b vts

2082:
2083: SELECT 1
2084: FROM AHL_OSP_ORDER_LINES ospl,
2085: AHL_WORKORDERS wo,
2086: ahl_visit_tasks_b vts
2087: WHERE ospl.workorder_id = wo.workorder_id
2088: AND ospl.osp_order_id = p_osp_id
2089: AND wo.visit_task_id = vts.visit_task_id
2090: AND vts.instance_id = p_csi_ii_id

Line 2118: ahl_visit_tasks_b vts

2114: --Modified by mpothuku on 21-Feb-06 to fix the Perf Bug #4919255
2115: SELECT 1
2116: FROM AHL_OSP_ORDER_LINES ospl,
2117: AHL_WORKORDERS wo,
2118: ahl_visit_tasks_b vts
2119: WHERE ospl.workorder_id = wo.workorder_id
2120: AND ospl.osp_order_id = p_osp_id
2121: AND wo.visit_task_id = vts.visit_task_id
2122: AND vts.instance_id = p_csi_ii_id

Line 2177: ahl_visit_tasks_b vts

2173: FROM AHL_OSP_ORDER_LINES ospl,
2174: OE_ORDER_LINES_ALL oe1,
2175: OE_ORDER_LINES_ALL oe2,
2176: AHL_WORKORDERS wo,
2177: ahl_visit_tasks_b vts
2178: WHERE ospl.oe_ship_line_id = oe1.line_id (+)
2179: AND ospl.oe_return_line_id = oe2.line_id (+)
2180: AND ospl.workorder_id = wo.workorder_id
2181: AND ospl.osp_order_id = p_osp_id

Line 2406: ahl_visit_tasks_b vts,

2402: vst.ORGANIZATION_ID,
2403: csii.lot_number
2404: FROM AHL_WORKORDERS wo,
2405: ahl_visits_b vst,
2406: ahl_visit_tasks_b vts,
2407: csi_item_instances csii
2408: WHERE wo.workorder_id = p_workorder_id
2409: AND wo.visit_task_id = vts.visit_task_id(+)
2410: AND vts.visit_id = vst.visit_id(+)

Line 4573: ahl_visit_tasks_b vts

4569: -- End Changes by jaramana on January 14, 2008 for the Requisition ER 6034236
4570: FROM AHL_OSP_ORDER_LINES a,
4571: ahl_workorders wo,
4572: csi_item_instances csii,
4573: ahl_visit_tasks_b vts
4574: WHERE a.osp_order_id = p_osp_id
4575: AND wo.workorder_id(+) = a.workorder_id
4576: AND wo.visit_task_id = vts.visit_task_id(+)
4577: AND csii.last_vld_organization_id(+) = a.inventory_org_id

Line 5720: ahl_visit_tasks_b vts,

5716: NVL(OE.shipped_quantity, 0)
5717: from ahl_osp_order_lines OSPL,
5718: oe_order_lines_all OE,
5719: ahl_workorders wo,
5720: ahl_visit_tasks_b vts,
5721: csi_item_instances csii
5722: where OSPL.osp_order_id = p_osp_order_id
5723: AND OSPL.OE_SHIP_LINE_ID IS NOT NULL
5724: AND OE.line_id = OSPL.OE_SHIP_LINE_ID