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 2121: ahl_visit_tasks_b vts

2117:
2118: SELECT 1
2119: FROM AHL_OSP_ORDER_LINES ospl,
2120: AHL_WORKORDERS wo,
2121: ahl_visit_tasks_b vts
2122: WHERE ospl.workorder_id = wo.workorder_id
2123: AND ospl.osp_order_id = p_osp_id
2124: AND wo.visit_task_id = vts.visit_task_id
2125: AND vts.instance_id = p_csi_ii_id

Line 2153: ahl_visit_tasks_b vts

2149: --Modified by mpothuku on 21-Feb-06 to fix the Perf Bug #4919255
2150: SELECT 1
2151: FROM AHL_OSP_ORDER_LINES ospl,
2152: AHL_WORKORDERS wo,
2153: ahl_visit_tasks_b vts
2154: WHERE ospl.workorder_id = wo.workorder_id
2155: AND ospl.osp_order_id = p_osp_id
2156: AND wo.visit_task_id = vts.visit_task_id
2157: AND vts.instance_id = p_csi_ii_id

Line 2212: ahl_visit_tasks_b vts

2208: FROM AHL_OSP_ORDER_LINES ospl,
2209: OE_ORDER_LINES_ALL oe1,
2210: OE_ORDER_LINES_ALL oe2,
2211: AHL_WORKORDERS wo,
2212: ahl_visit_tasks_b vts
2213: WHERE ospl.oe_ship_line_id = oe1.line_id (+)
2214: AND ospl.oe_return_line_id = oe2.line_id (+)
2215: AND ospl.workorder_id = wo.workorder_id
2216: AND ospl.osp_order_id = p_osp_id

Line 2441: ahl_visit_tasks_b vts,

2437: vst.ORGANIZATION_ID,
2438: csii.lot_number
2439: FROM AHL_WORKORDERS wo,
2440: ahl_visits_b vst,
2441: ahl_visit_tasks_b vts,
2442: csi_item_instances csii
2443: WHERE wo.workorder_id = p_workorder_id
2444: AND wo.visit_task_id = vts.visit_task_id(+)
2445: AND vts.visit_id = vst.visit_id(+)

Line 4557: ahl_visit_tasks_b vts

4553: -- End Changes by jaramana on January 14, 2008 for the Requisition ER 6034236
4554: FROM AHL_OSP_ORDER_LINES a,
4555: ahl_workorders wo,
4556: csi_item_instances csii,
4557: ahl_visit_tasks_b vts
4558: WHERE a.osp_order_id = p_osp_id
4559: AND wo.workorder_id(+) = a.workorder_id
4560: AND wo.visit_task_id = vts.visit_task_id(+)
4561: AND csii.last_vld_organization_id(+) = a.inventory_org_id

Line 4617: ahl_visit_tasks_b vts

4613: -- End Changes by jaramana on January 14, 2008 for the Requisition ER 6034236
4614: FROM AHL_OSP_ORDER_LINES a,
4615: ahl_workorders wo,
4616: csi_item_instances csii,
4617: ahl_visit_tasks_b vts
4618: WHERE a.osp_order_id = p_osp_id
4619: AND wo.workorder_id(+) = a.workorder_id
4620: AND wo.visit_task_id = vts.visit_task_id(+)
4621: AND csii.last_vld_organization_id(+) = a.inventory_org_id

Line 5765: ahl_visit_tasks_b vts,

5761: NVL(OE.shipped_quantity, 0)
5762: from ahl_osp_order_lines OSPL,
5763: oe_order_lines_all OE,
5764: ahl_workorders wo,
5765: ahl_visit_tasks_b vts,
5766: csi_item_instances csii
5767: where OSPL.osp_order_id = p_osp_order_id
5768: AND OSPL.OE_SHIP_LINE_ID IS NOT NULL
5769: AND OE.line_id = OSPL.OE_SHIP_LINE_ID