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.GMPMPACT dependencies on OE_SOLD_TO_ORGS_V

Line 1658: oe_sold_to_orgs_v sold_to_org,

1654: SELECT DISTINCT substr(sold_to_org.name,1,40)
1655: --DISTINCT sold_to_org.customer_number
1656: FROM oe_order_headers_all oh,
1657: oe_order_lines_all ol,
1658: oe_sold_to_orgs_v sold_to_org,
1659: mtl_demand_omoe mtl
1660: WHERE oh.header_id = ol.header_id
1661: AND ol.line_id = mtl.demand_id
1662: AND oh.sold_to_org_id = sold_to_org.organization_id(+)

Line 1677: oe_sold_to_orgs_v sold_to_org,

1673: SELECT DISTINCT substr(sold_to_org.name,1,40)
1674: -- DISTINCT sold_to_org.customer_number
1675: FROM oe_order_headers_all oh,
1676: oe_order_lines_all ol,
1677: oe_sold_to_orgs_v sold_to_org,
1678: mtl_demand_omoe mtl
1679: WHERE oh.header_id = ol.header_id
1680: AND ol.line_id = mtl.demand_id
1681: AND oh.sold_to_org_id = sold_to_org.organization_id(+)