[Home] [Help]
1986: ospl.osp_order_id,
1987: ospl.osp_order_line_id,
1988: ospl.osp_line_number,
1989: ospl.exchange_instance_id
1990: FROM AHL_WORKORDERS_OSP_V wo, AHL_OSP_ORDER_LINES ospl
1991: WHERE ospl.workorder_id = wo.workorder_id
1992: AND wo.job_number = p_wo_name
1993: AND ospl.osp_order_id = p_osp_id
1994: AND ospl.status_code IS NULL;
2038: ospl.osp_order_id,
2039: ospl.osp_order_line_id,
2040: ospl.osp_line_number,
2041: ospl.exchange_instance_id
2042: FROM AHL_WORKORDERS_OSP_V wo, AHL_OSP_ORDER_LINES ospl
2043: WHERE ospl.workorder_id = wo.workorder_id
2044: AND wo.item_instance_id = p_instance_id
2045: AND ospl.osp_order_id = p_osp_id
2046: AND ospl.status_code IS NULL;
2081: --Modified by mpothuku on 21-Feb-06 to fix the Perf Bug #4919255
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
2113:
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
2160: /*
2161: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2162: oe2.line_id, oe2.schedule_ship_date
2163: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2164: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b
2165: WHERE a.oe_ship_line_id = oe1.line_id (+)
2166: AND a.oe_return_line_id = oe2.line_id (+)
2167: AND a.workorder_id = b.workorder_id
2168: AND a.osp_order_id = p_osp_id
2172: oe2.line_id, oe2.schedule_ship_date
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
2388: wo.project_id,
2389: wo.project_task_id,
2390: wo.ORGANIZATION_ID,
2391: wo.lot_number --jeli 12/01/05
2392: FROM AHL_WORKORDERS_OSP_V wo
2393: WHERE wo.workorder_id = p_workorder_id ;
2394: */
2395: SELECT vts.inventory_item_id,
2396: csii.serial_number,
2400: vst.project_id,
2401: vts.project_task_id,
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
4509: a.ATTRIBUTE13,
4510: a.ATTRIBUTE14,
4511: a.ATTRIBUTE15
4512:
4513: -- FROM AHL_OSP_ORDER_LINES a, AHL_WORKORDERS_V b
4514: -- WHERE a.workorder_id = b.workorder_id
4515: -- AND a.osp_order_id = p_osp_id
4516: -- AND b.item_instance_id = p_csi_ii_id;
4517:
4567: -- Begin Changes by jaramana on January 14, 2008 for the Requisition ER 6034236
4568: a.PO_REQ_LINE_ID
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
5704: SELECT OSPL.OE_SHIP_LINE_ID,
5705: ospl.item_instance_id,
5706: --wo.item_instance_id, --Jeli on 01/24/2006 for ER 4746426
5707: NVL(OE.shipped_quantity, 0)
5708: from ahl_osp_order_lines_v OSPL, oe_order_lines_all OE --, AHL_WORKORDERS_OSP_V wo
5709: where OSPL.osp_order_id = p_osp_order_id AND
5710: --ospl.workorder_id = wo.workorder_id AND
5711: OSPL.OE_SHIP_LINE_ID IS NOT NULL AND
5712: OE.line_id = OSPL.OE_SHIP_LINE_ID;
5715: decode(wo.workorder_id, null, csii.instance_id, vts.instance_id) item_instance_id,
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