APPS.AHL_OSP_PO_PVT dependencies on AHL_OSP_ORDERS_VL

Line 1690: SELECT OSP_ORDER_NUMBER, DESCRIPTION FROM AHL_OSP_ORDERS_VL

1686: x_intf_header_id OUT NOCOPY NUMBER,
1687: x_batch_id OUT NOCOPY NUMBER) IS
1688:
1689: CURSOR l_get_osp_order_dtls_csr(p_osp_order_id IN NUMBER) IS
1690: SELECT OSP_ORDER_NUMBER, DESCRIPTION FROM AHL_OSP_ORDERS_VL
1691: WHERE OSP_ORDER_ID = p_osp_order_id;
1692:
1693: l_description VARCHAR2(256);
1694: l_OSP_description VARCHAR2(256) := NULL;

Line 3122: FROM AHL_OSP_ORDERS_VL

3118: ATTRIBUTE14,
3119: ATTRIBUTE15,
3120: DESCRIPTION,
3121: PO_REQ_HEADER_ID -- Added by jaramana on January 7, 2008 for the Requisition ER 6034236
3122: FROM AHL_OSP_ORDERS_VL
3123: WHERE OSP_ORDER_ID = p_osp_order_id;
3124:
3125: l_osp_dtls_rec l_osp_dtls_csr%ROWTYPE;
3126: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_OSP_Order';