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 1621: FROM OE_SHIP_TO_ORGS_V

1617: WHERE customer_number = p_cust_number;
1618:
1619: CURSOR ahl_ship_to_orgs_csr(p_name IN VARCHAR2, p_sold_to_org_id IN NUMBER) IS
1620: SELECT organization_id
1621: FROM OE_SHIP_TO_ORGS_V
1622: WHERE customer_id = p_sold_to_org_id
1623: AND name = p_name;
1624:
1625: CURSOR ahl_sold_to_contact_count_csr(p_sold_to_contact IN VARCHAR2, p_sold_to_org_id IN NUMBER) IS

Line 1654: select customer_id from OE_SHIP_TO_ORGS_V

1650: HZ_CUST_SITE_USES_ALL site
1651: WHERE site.cust_acct_site_id = acc.cust_acct_site_id
1652: and SITE_USE_ID = p_customer_site_id;*/
1653:
1654: select customer_id from OE_SHIP_TO_ORGS_V
1655: where organization_id = p_customer_site_id;
1656:
1657: CURSOR ahl_get_ship_from_org_csr(p_osp_order_id IN NUMBER) IS
1658: SELECT inventory_org_id