DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on AHL_VENDOR_CUSTOMER_RELS_V

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 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