APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_OSP_ORDERS_VL

Line 862: FROM ahl_osp_orders_vl

858: SELECT osp_order_number, order_type_code, single_instance_flag, po_header_id, oe_header_id,vendor_id, vendor_site_id,
859: customer_id,order_date,contract_id,contract_terms,operating_unit_id, po_synch_flag, status_code,
860: po_batch_id, po_request_id,po_agent_id, po_interface_header_id, po_req_header_id , description, vendor_contact_id
861: -- jaramana End
862: FROM ahl_osp_orders_vl
863: WHERE osp_order_id = p_osp_order_id
864: AND object_version_number = p_object_version_number;
865:
866: -- Added by jaramana on January 8, 2008 for the Requisition ER 6034236

Line 1971: FROM ahl_osp_orders_vl

1967: po_batch_id, po_request_id,po_agent_id, po_interface_header_id, po_req_header_id, description,attribute_category,
1968: attribute1,attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
1969: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, vendor_contact_id
1970: -- jaramana End
1971: FROM ahl_osp_orders_vl
1972: WHERE osp_order_id = p_osp_order_id
1973: AND object_version_number= p_object_version_number;
1974: l_osp_order_rec osp_order_rec_type;
1975: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.default_unchanged_order_header';