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.CHV_LOAD_ORDERS dependencies on PO_HEADERS

Line 641: vendor site. This will use better indexes on the PO_HEADERS and MTL_SUPPLY

637: /* Bug - 993145 - Added the need_by_date is NOT NULL condition in the
638: ** WHERE clause to avoid loading the NON Planned items. */
639:
640: /* Bug 1769274 Added +0 to the poh.vendor_id to diable the index on vendor and
641: vendor site. This will use better indexes on the PO_HEADERS and MTL_SUPPLY
642: tables and hence will improve the performance.
643: */
644: /* Bug 4618577 fixed. Added format mask to to_date function */
645: /* Bug 5075549 fixed. Removed the to_date function to date columns */

Line 654: from po_headers poh,

650: ms.po_line_location_id,
651: ms.to_org_primary_quantity,
652: ms.to_org_primary_uom,
653: ms.need_by_date
654: from po_headers poh,
655: mtl_supply ms
656: where ms.to_organization_id = x_organization_id
657: and ms.supply_type_code in ('PO','SHIPMENT')
658: and ms.po_header_id = poh.po_header_id