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_SHIPMENT_PUB dependencies on OE_SHIP_TO_ORGS_V

Line 1586: FROM OE_SHIP_TO_ORGS_V

1582: WHERE customer_number = p_cust_number;
1583:
1584: CURSOR ahl_ship_to_orgs_csr(p_name IN VARCHAR2, p_sold_to_org_id IN NUMBER) IS
1585: SELECT organization_id
1586: FROM OE_SHIP_TO_ORGS_V
1587: WHERE customer_id = p_sold_to_org_id
1588: AND name = p_name;
1589:
1590: CURSOR ahl_sold_to_contact_count_csr(p_sold_to_contact IN VARCHAR2, p_sold_to_org_id IN NUMBER) IS

Line 1619: select customer_id from OE_SHIP_TO_ORGS_V

1615: HZ_CUST_SITE_USES_ALL site
1616: WHERE site.cust_acct_site_id = acc.cust_acct_site_id
1617: and SITE_USE_ID = p_customer_site_id;*/
1618:
1619: select customer_id from OE_SHIP_TO_ORGS_V
1620: where organization_id = p_customer_site_id;
1621:
1622: CURSOR ahl_get_ship_from_org_csr(p_osp_order_id IN NUMBER) IS
1623: SELECT inventory_org_id