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.WMS_RULES_WORKBENCH_PVT dependencies on PO_HEADERS_ALL

Line 1800: from po_headers_all poh,

1796: -- MOAC: _ALL tables replace views in next three select statements
1797: -- existing where clauses sufficient to stripe by OU
1798:
1799: select poh.vendor_id into l_vendor_id
1800: from po_headers_all poh,
1801: po_lines_all pol,
1802: po_line_locations_all pll
1803: where poh.po_header_id = pol.po_header_id
1804: and pll.po_header_id = pol.po_header_id

Line 1811: from po_headers_all poh,

1807: and pll.line_location_id = p_reference_id ;
1808:
1809: elsif (p_reference = 'PO_DISTRIBUTION_ID' ) then
1810: select poh.vendor_id into l_vendor_id
1811: from po_headers_all poh,
1812: po_lines_all pol,
1813: po_distributions_all pod,
1814: po_line_locations_all pll
1815: where poh.po_header_id = pol.po_header_id

Line 1825: from po_headers_all poh,

1821: and pll.shipment_type = 'STANDARD'
1822: and pod.po_distribution_id = p_reference_id;
1823: Else
1824: select poh.vendor_id into l_vendor_id
1825: from po_headers_all poh,
1826: po_lines_all pol,
1827: rcv_transactions rct,
1828: po_line_locations_all pll
1829: where poh.po_header_id = pol.po_header_id