APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_OSP_ORDERS_VL

Line 841: FROM ahl_osp_orders_vl

837: SELECT osp_order_number, order_type_code, single_instance_flag, po_header_id, oe_header_id,vendor_id, vendor_site_id,
838: customer_id,order_date,contract_id,contract_terms,operating_unit_id, po_synch_flag, status_code,
839: po_batch_id, po_request_id,po_agent_id, po_interface_header_id, po_req_header_id , description, vendor_contact_id
840: -- jaramana End
841: FROM ahl_osp_orders_vl
842: WHERE osp_order_id = p_osp_order_id
843: AND object_version_number = p_object_version_number;
844:
845: -- Added by jaramana on January 8, 2008 for the Requisition ER 6034236

Line 1950: FROM ahl_osp_orders_vl

1946: po_batch_id, po_request_id,po_agent_id, po_interface_header_id, po_req_header_id, description,attribute_category,
1947: attribute1,attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
1948: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, vendor_contact_id
1949: -- jaramana End
1950: FROM ahl_osp_orders_vl
1951: WHERE osp_order_id = p_osp_order_id
1952: AND object_version_number= p_object_version_number;
1953: l_osp_order_rec osp_order_rec_type;
1954: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.default_unchanged_order_header';