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_QUERIES_PVT dependencies on AHL_OSP_ORDER_LINES

Line 244: || ' AHL_OSP_ORDER_LINES OL WHERE '

240: LI_Field_Exist := TRUE;
241: END IF;
242: IF P_search_order_rec.Department IS NOT NULL THEN
243: l_search_criteria := l_search_criteria || and_str || ' EXISTS (SELECT OL.OSP_ORDER_LINE_ID FROM AHL_WORKORDERS_OSP_V WO, '
244: || ' AHL_OSP_ORDER_LINES OL WHERE '
245: || ' OL.OSP_ORDER_ID = OSP.OSP_ORDER_ID AND OL.WORKORDER_ID = WO.WORKORDER_ID ';
246: --|| ' AND UPPER(WO.DEPARTMENT_CODE) LIKE UPPER('''|| P_search_order_rec.Department || ''')) ';
247:
248: IF P_search_order_rec.department_id IS NOT NULL THEN

Line 279: l_from_string := l_from_string || ', AHL_OSP_ORDER_LINES_V LI ';

275: END IF;
276:
277:
278: IF LI_Field_Exist THEN
279: l_from_string := l_from_string || ', AHL_OSP_ORDER_LINES_V LI ';
280: l_search_criteria := l_search_criteria || ' AND LI.OSP_ORDER_ID = OSP.OSP_ORDER_ID ';
281: END IF;
282:
283: l_sql_string := l_sql_string || l_from_string ;

Line 543: l_search_criteria := l_search_criteria || ' AND NOT EXISTS (SELECT OL1.WORKORDER_ID FROM AHL_OSP_ORDER_LINES OL1 WHERE OL1.WORKORDER_ID = WO.WORKORDER_ID AND OL1.STATUS_CODE IS NULL) ';

539: and_str := ' ';
540:
541: l_search_criteria := l_search_criteria || ' WO.DEPARTMENT_CLASS_CODE = ''' || G_VENDOR_DEPT_CLASS_CODE || '''';
542: l_search_criteria := l_search_criteria || ' AND WO.JOB_STATUS_CODE = ''3'' ';
543: l_search_criteria := l_search_criteria || ' AND NOT EXISTS (SELECT OL1.WORKORDER_ID FROM AHL_OSP_ORDER_LINES OL1 WHERE OL1.WORKORDER_ID = WO.WORKORDER_ID AND OL1.STATUS_CODE IS NULL) ';
544:
545:
546: -- l_search_criteria := l_search_criteria || ' (WO.WORKORDER_ID NOT IN (SELECT WORKORDER_ID FROM AHL_OSP_ORDER_LINES) OR WO.WORKORDER_ID IN (SELECT WORKORDER_ID FROM AHL_OSP_ORDER_LINES WHERE JOB_STATUS_CODE IN (''PO_DELETED'', ''PO_CANCEL''))) ';
547:

Line 546: -- l_search_criteria := l_search_criteria || ' (WO.WORKORDER_ID NOT IN (SELECT WORKORDER_ID FROM AHL_OSP_ORDER_LINES) OR WO.WORKORDER_ID IN (SELECT WORKORDER_ID FROM AHL_OSP_ORDER_LINES WHERE JOB_STATUS_CODE IN (''PO_DELETED'', ''PO_CANCEL''))) ';

542: l_search_criteria := l_search_criteria || ' AND WO.JOB_STATUS_CODE = ''3'' ';
543: l_search_criteria := l_search_criteria || ' AND NOT EXISTS (SELECT OL1.WORKORDER_ID FROM AHL_OSP_ORDER_LINES OL1 WHERE OL1.WORKORDER_ID = WO.WORKORDER_ID AND OL1.STATUS_CODE IS NULL) ';
544:
545:
546: -- l_search_criteria := l_search_criteria || ' (WO.WORKORDER_ID NOT IN (SELECT WORKORDER_ID FROM AHL_OSP_ORDER_LINES) OR WO.WORKORDER_ID IN (SELECT WORKORDER_ID FROM AHL_OSP_ORDER_LINES WHERE JOB_STATUS_CODE IN (''PO_DELETED'', ''PO_CANCEL''))) ';
547:
548: IF p_search_WO_rec.job_number IS NOT NULL THEN
549: l_search_criteria := l_search_criteria || ' AND UPPER(JOB_NUMBER) LIKE UPPER (:b' || l_bind_index || ')';
550: l_conditions(l_bind_index) := p_search_WO_rec.job_number;

Line 1273: l_line_queries := l_line_queries || ' FROM AHL_OSP_ORDER_LINES_V ';

1269: l_line_queries := l_line_queries ||', PROJECT_NAME ';
1270: l_line_queries := l_line_queries ||', PROJECT_TASK_ID ';
1271: l_line_queries := l_line_queries ||', PROJECT_TASK_NAME ';
1272:
1273: l_line_queries := l_line_queries || ' FROM AHL_OSP_ORDER_LINES_V ';
1274: l_line_queries := l_line_queries || ' WHERE OSP_ORDER_ID = ';
1275: l_line_queries := l_line_queries || P_OSP_ID;
1276: l_line_queries := l_line_queries || ' ORDER BY OSP_LINE_NUMBER ';
1277:

Line 1624: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp where

1620: Select
1621: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
1622: (ospl.inventory_item_id,ospl.inventory_item_uom,ospl.inventory_item_quantity),0)
1623: ),0) into l_quant_withoutship
1624: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp where
1625: ospl.osp_order_id = osp.osp_order_id and
1626: osp.status_code <> 'CLOSED' and
1627: --Added by mpothuku on 23-Aug-06 to exclude the quantity involved in PO_CANCELLED or PO_DELETED Lines for Bug 5252627
1628: ospl.status_code is null and

Line 1655: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp,

1651: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
1652: (ospl.inventory_item_id,ospl.inventory_item_uom,ospl.inventory_item_quantity),0)
1653: ),0) into l_quant_ship_notbooked
1654:
1655: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp,
1656: /* Fix for the AE Bug 5673279 (Release/Holding of inventory items) */
1657: oe_order_lines_all oel
1658: where
1659: ospl.osp_order_id = osp.osp_order_id and