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 PO_APPROVED_SUPPLIER_LIST

Line 1744: from PO_VENDORS_VIEW VEN, PO_ASL_STATUSES AST, PO_APPROVED_SUPPLIER_LIST ASL, AHL_WORKORDERS_OSP_V WO

1740: CURSOR l_approved_vendors_csr(l_workorder_id IN NUMBER,
1741: l_org_id IN NUMBER) IS
1742: /*
1743: SELECT VENDOR_NAME
1744: from PO_VENDORS_VIEW VEN, PO_ASL_STATUSES AST, PO_APPROVED_SUPPLIER_LIST ASL, AHL_WORKORDERS_OSP_V WO
1745: WHERE WO.WORKORDER_ID = l_workorder_id AND
1746: ASL.ITEM_ID = WO.SERVICE_ITEM_ID AND
1747: (ASL.USING_ORGANIZATION_ID = l_org_id OR
1748: (ASL.OWNING_ORGANIZATION_ID = l_org_id AND ASL.USING_ORGANIZATION_ID = -1)) AND

Line 1760: PO_APPROVED_SUPPLIER_LIST ASL,

1756: -- Modified by mpothuku on 13-Mar-06 to fix the Perf Bug #4919307
1757: SELECT VENDOR_NAME
1758: from PO_VENDORS_VIEW VEN,
1759: PO_ASL_STATUSES AST,
1760: PO_APPROVED_SUPPLIER_LIST ASL,
1761: AHL_WORKORDERS WO,
1762: AHL_ROUTES_B arb
1763: WHERE WO.WORKORDER_ID = l_workorder_id
1764: AND arb.route_id = wo.route_id