APPS.AHL_OSP_PO_PVT dependencies on AHL_OSP_ORDERS_VL

Line 1698: SELECT OSP_ORDER_NUMBER, DESCRIPTION FROM AHL_OSP_ORDERS_VL

1694: x_intf_header_id OUT NOCOPY NUMBER,
1695: x_batch_id OUT NOCOPY NUMBER) IS
1696:
1697: CURSOR l_get_osp_order_dtls_csr(p_osp_order_id IN NUMBER) IS
1698: SELECT OSP_ORDER_NUMBER, DESCRIPTION FROM AHL_OSP_ORDERS_VL
1699: WHERE OSP_ORDER_ID = p_osp_order_id;
1700:
1701: l_description VARCHAR2(256);
1702: l_OSP_description VARCHAR2(256) := NULL;

Line 3155: FROM AHL_OSP_ORDERS_VL

3151: ATTRIBUTE14,
3152: ATTRIBUTE15,
3153: DESCRIPTION,
3154: PO_REQ_HEADER_ID -- Added by jaramana on January 7, 2008 for the Requisition ER 6034236
3155: FROM AHL_OSP_ORDERS_VL
3156: WHERE OSP_ORDER_ID = p_osp_order_id;
3157:
3158: l_osp_dtls_rec l_osp_dtls_csr%ROWTYPE;
3159: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_OSP_Order';