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 1639: ahl_vendor_customer_rels_v cust

1635: osp.osp_order_number,
1636: cust.customer_site_id,
1637: cust.customer_id
1638: FROM ahl_osp_orders_b osp,
1639: ahl_vendor_customer_rels_v cust
1640: WHERE osp.osp_order_id = p_osp_order_id
1641: AND osp.vendor_site_id = cust.vendor_site_id;
1642:
1643: l_vendor_cust_dtls ahl_order_vendor_detls_csr%ROWTYPE;

Line 6125: FROM AHL_VENDOR_CUSTOMER_RELS

6121:
6122: CURSOR check_cust_vendor_rel
6123: IS
6124: SELECT CUSTOMER_SITE_ID
6125: FROM AHL_VENDOR_CUSTOMER_RELS
6126: WHERE VENDOR_SITE_ID = p_vendor_loc_id;
6127:
6128: CURSOR ahl_order_vendor_detls_csr(p_osp_order_id IN NUMBER) IS
6129: SELECT osp.vendor_id,

Line 6136: ahl_vendor_customer_rels_v cust

6132: osp.osp_order_number,
6133: cust.customer_site_id,
6134: cust.customer_id
6135: FROM ahl_osp_orders_b osp,
6136: ahl_vendor_customer_rels_v cust
6137: WHERE osp.osp_order_id = p_osp_order_id
6138: AND osp.vendor_site_id = cust.vendor_site_id;
6139:
6140: CURSOR get_oe_order_lines(c_oe_header_id IN NUMBER) IS