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_WORKORDERS

Line 2025: FROM AHL_WORKORDERS_OSP_V wo, AHL_OSP_ORDER_LINES ospl

2021: ospl.osp_order_id,
2022: ospl.osp_order_line_id,
2023: ospl.osp_line_number,
2024: ospl.exchange_instance_id
2025: FROM AHL_WORKORDERS_OSP_V wo, AHL_OSP_ORDER_LINES ospl
2026: WHERE ospl.workorder_id = wo.workorder_id
2027: AND wo.job_number = p_wo_name
2028: AND ospl.osp_order_id = p_osp_id
2029: AND ospl.status_code IS NULL;

Line 2077: FROM AHL_WORKORDERS_OSP_V wo, AHL_OSP_ORDER_LINES ospl

2073: ospl.osp_order_id,
2074: ospl.osp_order_line_id,
2075: ospl.osp_line_number,
2076: ospl.exchange_instance_id
2077: FROM AHL_WORKORDERS_OSP_V wo, AHL_OSP_ORDER_LINES ospl
2078: WHERE ospl.workorder_id = wo.workorder_id
2079: AND wo.item_instance_id = p_instance_id
2080: AND ospl.osp_order_id = p_osp_id
2081: AND ospl.status_code IS NULL;

Line 2120: AHL_WORKORDERS wo,

2116: --Modified by mpothuku on 21-Feb-06 to fix the Perf Bug #4919255
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

Line 2152: AHL_WORKORDERS wo,

2148:
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

Line 2199: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b

2195: /*
2196: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2197: oe2.line_id, oe2.schedule_ship_date
2198: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2199: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b
2200: WHERE a.oe_ship_line_id = oe1.line_id (+)
2201: AND a.oe_return_line_id = oe2.line_id (+)
2202: AND a.workorder_id = b.workorder_id
2203: AND a.osp_order_id = p_osp_id

Line 2211: AHL_WORKORDERS wo,

2207: oe2.line_id, oe2.schedule_ship_date
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

Line 2427: FROM AHL_WORKORDERS_OSP_V wo

2423: wo.project_id,
2424: wo.project_task_id,
2425: wo.ORGANIZATION_ID,
2426: wo.lot_number --jeli 12/01/05
2427: FROM AHL_WORKORDERS_OSP_V wo
2428: WHERE wo.workorder_id = p_workorder_id ;
2429: */
2430: SELECT vts.inventory_item_id,
2431: csii.serial_number,

Line 2439: FROM AHL_WORKORDERS wo,

2435: vst.project_id,
2436: vts.project_task_id,
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

Line 4497: -- FROM AHL_OSP_ORDER_LINES a, AHL_WORKORDERS_V b

4493: a.ATTRIBUTE13,
4494: a.ATTRIBUTE14,
4495: a.ATTRIBUTE15
4496:
4497: -- FROM AHL_OSP_ORDER_LINES a, AHL_WORKORDERS_V b
4498: -- WHERE a.workorder_id = b.workorder_id
4499: -- AND a.osp_order_id = p_osp_id
4500: -- AND b.item_instance_id = p_csi_ii_id;
4501:

Line 4555: ahl_workorders wo,

4551: -- Begin Changes by jaramana on January 14, 2008 for the Requisition ER 6034236
4552: a.PO_REQ_LINE_ID
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

Line 4615: ahl_workorders wo,

4611: -- Begin Changes by jaramana on January 14, 2008 for the Requisition ER 6034236
4612: a.PO_REQ_LINE_ID
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

Line 5753: from ahl_osp_order_lines_v OSPL, oe_order_lines_all OE --, AHL_WORKORDERS_OSP_V wo

5749: SELECT OSPL.OE_SHIP_LINE_ID,
5750: ospl.item_instance_id,
5751: --wo.item_instance_id, --Jeli on 01/24/2006 for ER 4746426
5752: NVL(OE.shipped_quantity, 0)
5753: from ahl_osp_order_lines_v OSPL, oe_order_lines_all OE --, AHL_WORKORDERS_OSP_V wo
5754: where OSPL.osp_order_id = p_osp_order_id AND
5755: --ospl.workorder_id = wo.workorder_id AND
5756: OSPL.OE_SHIP_LINE_ID IS NOT NULL AND
5757: OE.line_id = OSPL.OE_SHIP_LINE_ID;

Line 5764: ahl_workorders wo,

5760: decode(wo.workorder_id, null, csii.instance_id, vts.instance_id) item_instance_id,
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