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 AHL_VENDOR_CUSTOMER_RELS

Line 1604: ahl_vendor_customer_rels_v cust

1600: osp.osp_order_number,
1601: cust.customer_site_id,
1602: cust.customer_id
1603: FROM ahl_osp_orders_b osp,
1604: ahl_vendor_customer_rels_v cust
1605: WHERE osp.osp_order_id = p_osp_order_id
1606: AND osp.vendor_site_id = cust.vendor_site_id;
1607:
1608: l_vendor_cust_dtls ahl_order_vendor_detls_csr%ROWTYPE;

Line 6080: FROM AHL_VENDOR_CUSTOMER_RELS

6076:
6077: CURSOR check_cust_vendor_rel
6078: IS
6079: SELECT CUSTOMER_SITE_ID
6080: FROM AHL_VENDOR_CUSTOMER_RELS
6081: WHERE VENDOR_SITE_ID = p_vendor_loc_id;
6082:
6083: CURSOR ahl_order_vendor_detls_csr(p_osp_order_id IN NUMBER) IS
6084: SELECT osp.vendor_id,

Line 6091: ahl_vendor_customer_rels_v cust

6087: osp.osp_order_number,
6088: cust.customer_site_id,
6089: cust.customer_id
6090: FROM ahl_osp_orders_b osp,
6091: ahl_vendor_customer_rels_v cust
6092: WHERE osp.osp_order_id = p_osp_order_id
6093: AND osp.vendor_site_id = cust.vendor_site_id;
6094:
6095: CURSOR get_oe_order_lines(c_oe_header_id IN NUMBER) IS