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.OE_ORDER_CACHE dependencies on OE_SHIP_TO_ORGS_V

Line 428: FROM OE_SHIP_TO_ORGS_V

424: , g_ship_to_rec.contact_id
425: , g_ship_to_rec.ship_partial_allowed
426: , g_ship_to_rec.shipping_method_code
427: , l_bill_to_site_use_id
428: FROM OE_SHIP_TO_ORGS_V
429: WHERE ORGANIZATION_ID = p_key;
430:
431: -- Fetch Invoice to org id.
432:

Line 797: FROM OE_SHIP_TO_ORGS_V SHIP

793: BEGIN
794:
795: SELECT /*MOAC_SQL_CHANGES*/ SHIP.ORGANIZATION_ID
796: INTO g_sold_to_rec.ship_to_org_id
797: FROM OE_SHIP_TO_ORGS_V SHIP
798: , HZ_CUST_ACCT_SITES_ALL ADDR
799: WHERE ADDR.CUST_ACCOUNT_ID = p_key
800: AND ADDR.SHIP_TO_FLAG = 'P'
801: AND ADDR.STATUS = 'A'